Forum Discussion
Pivot table data source remains fixed when copying sheets
Change default setting of Pvt by uncheck "source data with file" from then while moving the sheet pvt will pick new sheet data source. tfmeier
Ok, this is what I've done:
- Changed the setting 'save source data with file' in the pivot table in sheet Rev-0
- Made a copy of Rev-0 > Rev-1
- Checked the data source of the pivot in Rev-1; it still points to the table in Rev-0
I'm using the latest version of Excel
- I'm running into this issue right now, did you ever find a fix?
This seems to have never been resolved here. My issue is even slightly weirder. In my original sheet, I gave the source data range a new name. Now, when I copy that sheet the PT on the new sheet refers to the OLD name of the data range on the original sheet! Blows my mind how this all gets retained in the background. I am trying to refresh caches, etc, but have not found a solution yet. Any thoughts out there?
Best to ignore my previous contribution; turns out the source table of the pivot table had been "hard coded" in VBA. Was easily fixed in the end. I'd be happy to provide the related VBA code on request.
