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