FinancialAnalystKid
Well-known Member
- Joined
- Oct 14, 2004
- Messages
- 779
This has never happened to me. For years! And suddenly this is happening.
For years I've copied workbooks and renamed them or used "SAVE AS" to create another version.
v1, v2... etc.
Pivot Tables and the Source stay within that workbook. But now- the source points to original file!
So if I save v1 as v2 the pivots on workbook v2 are pointing to data in v1!
I have to change data source on ALL the pivot tables and I can't figure out why this is happening!
Any help would be appreciated!
For years I've copied workbooks and renamed them or used "SAVE AS" to create another version.
v1, v2... etc.
Pivot Tables and the Source stay within that workbook. But now- the source points to original file!
So if I save v1 as v2 the pivots on workbook v2 are pointing to data in v1!
I have to change data source on ALL the pivot tables and I can't figure out why this is happening!
Any help would be appreciated!