Pivot Table Data Source Issue

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!
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

chicagocomputerclasses

Well-known Member
Joined
Mar 2, 2015
Messages
645
Which version of excel is this?

When you right click on Pivot Table-> Pivot Table Options->Data->Save Source Data With File is it checked?
 

FinancialAnalystKid

Well-known Member
Joined
Oct 14, 2004
Messages
779
Original file: CVI Program.xlsx
Source: Encounters!$A$3:$BB$4373


New File: CVI Program (v2).xlsx
Soucre: '[CVI Program.xlsx]Encounters'!$A$3:$BB$4373

Still points to original source.
 

chicagocomputerclasses

Well-known Member
Joined
Mar 2, 2015
Messages
645
When you right click on Pivot Table-> Pivot Table Options->Data->Save Source Data With File.

Uncheck and try again. Let me know.​




 

Forum statistics

Threads
1,089,284
Messages
5,407,371
Members
403,138
Latest member
jay_py

This Week's Hot Topics

Top