Hi,
My workbook contains several pivots from different sources. On one pivot I've deleted the source therefore the data is all in the cache. My problem is that when I refresh the workbook I get an annoying "Cannot open pivot table source file". Is there an simple way of preventing that specific pivot table from refreshing when all the others are ? Any help would be appreciated !
Thanks
amphinomos
You may try:
You must change sheet and table names.
Please Login or Register to view this content.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Protect the worksheet containing that pivot table.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Hi Izandol,
Many thanks for your answer. I was thinking of doing a for loop if ever I had pivot tables. I get an error though with the code below (apologies if this looks like gibberish I'm still on my way learning vba) :
Please Login or Register to view this content.
instead of this:Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks again Izandol. I still get an error despite that I corrected pt to a PivotTable object.
Please Login or Register to view this content.
Oh I have missed this:
Please Login or Register to view this content.
Perfect Izandol. Thanks again !
You are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks