2013 Pivot table issue: data source table identified with file name

AlisaA

Board Regular
Joined
Mar 17, 2010
Messages
193
I have a file that contains several pivot tables originating from a data table contained within the spreadsheet. The table name is TurnData, but the data source is treated as 'GPS Turnover - P05 2015.xlsx'!TurnData. I can successfully remove the file reference from the data source, but once I save, close, and reopen the file, the file name reference returns.

Then when I create the new period's file, the pivot tables link to the previous period's spreadsheet because of the file name reference. It does not matter if I make a copy of the spreadsheet in Windows Explorer or do a file/save as to create the new file. Then I have to go into each pivot table and change each data source individually to relink to the correct table.

I have tried using both pivot table options: "Data/Save source data with file" checked and unchecked. Neither one makes a difference.

Does anyone know the solution to this issue? Thank you in advance for your help!
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

AlisaA

Board Regular
Joined
Mar 17, 2010
Messages
193
I am still having this problem, does ANYONE know what causes this to happen? I have now gotten rid of the table and just link to the data range on a separate tab within the same file. Same issue - each new period file links back to the previous period file. Please help!! Thank you!!
 

Watch MrExcel Video

Forum statistics

Threads
1,123,474
Messages
5,601,872
Members
414,479
Latest member
Beau the dog

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top