Hi I have some pivot tables on different sheets where I have disabled the field settings, when i try enable the field settings i get the following message Runtime Error '1004': Method 'Pivot Tables' of object '_Worksheet' Failed. this only occurs on 1 of the sheets from a total of 6 sheets. i have included the code below. I am unable to enable the field settings in the pivots as this error keeps on appearing.
Please Login or Register to view this content.
Do you actually have 7 pivot tables on Sheet11?
Everyone who confuses correlation and causation ends up dead.
No I actually only have 3 pivot tables, I have about 15 pivot tables all located on different sheets.
That's why you're getting an error. You should refer to them by name or use 1-3 as the indices, not 5-7.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks