I have a file with pivot tables connected to a table in a separate sheet (in the same file). The table is connected to a datasource (an access database) and I save the file with a new name and update the data in the sheet. When I try to refresh the pivot tables to reflect the new data they have the old file name in the datasource causing them to not being able to update (i.e. 'File name 2015 3 - RR.xlsb'!TableName instead of just TableName).

In Excel 2010 it worked fine resaving the file with a new name and refreshing the pivots. how do I fix this problem? I've been trying to update the datasource by removing the file name but that's not working because it's still asking for the old file.

/A

Hi Bylla77,   This is a known problem in 2013 I seem to recall.   Perhaps you can connect the pivot table to the external source directly?    

Hi,

Thanks for the suggestion. I will try that.

Do you have any link to the bug information?

/A

Hi,

As far as I know, this issue might be caused by the Excel file contain the personal information(data source), such as Access database name, path. etc... After we closed the file, Excel 2013 generated the full name and path of the data source and stored in the file. If we renamed the file, Excel could not find the original file name. Thus, please try the 2 workarounds:

===

One:

Create a copy of file as test file =>Change the file edition from XLSB to ZIP. =>Double click the Zip=>Go to test one1.zip\xl\pivotCache\pivotCacheDefinition1.xml => Open pivotCacheDefinition1.xml in Notepad.=> Find <worksheetSource name="Access database name.accdb" r:id="rId2"/> => change rId2 to rid1. => Change Zip to XLSB

Two:

Use XLS format.

===

Hope it's helpful.

Regards,

George Zhao
TechNet Community Support