Microsoft Office Forums Pivot Fields get Error 1004

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-18-2019, 08:52 AM
mike.demos@morganplc.com mike.demos@morganplc.com is offline Pivot Fields get Error 1004 Windows XP Pivot Fields get Error 1004 Office 2016
Novice
Pivot Fields get Error 1004
 
Join Date: Oct 2019
Posts: 1
mike.demos@morganplc.com is on a distinguished road
Default Pivot Fields get Error 1004

Hi. I recorded a macro to create a pivot table. When I try to run the macro, I get the 1004 error (Application defined or object defined error) for these three commands. Any insight on how I can correct this?






.DisplayMemberPropertyTooltips = False
.AllowMultipleFilters = True .CalculatedMembersInFilters = False


Thanks!


Mike.




Reply With Quote
  #2  
Old 10-20-2019, 05:47 PM
Guessed's Avatar
Guessed Guessed is offline Pivot Fields get Error 1004 Windows 10 Pivot Fields get Error 1004 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 1,343
Guessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the roughGuessed is a jewel in the rough
Default

Those three lines need to be preceded by a line that starts with "With ..." and followed by a line that says "End With"

The .DisplayMemberPropertyTooltips is saying it is a member of that thing that follows the With statement.

Does your code include that With statement (and you haven't posted it) or is that missing in your code too?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Suddenly having trouble using .Refresh BackgroundQuery. Error 1004, General ODBC Error PLSBRYDOBOY Excel Programming 0 08-30-2019 12:17 PM
Pivot Fields get Error 1004 Error 1004 on EnvelopeVisable mamies Excel Programming 4 03-01-2017 05:14 PM
Run Time Error '1004' galkej Excel 0 02-03-2014 06:39 AM
Pivot Fields get Error 1004 Run time error 1004 yonasan Excel Programming 3 06-12-2012 11:08 PM
Pivot Fields get Error 1004 runtime error 1004 gbaker Excel Programming 11 06-06-2012 05:23 AM


All times are GMT -7. The time now is 05:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft