Forum Discussion
Pivot table data source remains fixed when copying sheets
I have workbook with sheet Rev-0. This sheet contains a table (cols A-G) and a pivot table (col. J) accessing the table in cols A-G. The table is named (Rev_0). I's possible that a copy needs to ...
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?
