Can't Open Pivot Table Source File '[Dashboard-MCT.xlsm]Resources2-Calc'

[nicolassido34]

Hello everyone,

I am having an issue with Pivot Tables in Excel and would really appreciate any help.

I have an Excel file named 'Dashboard-MCT' with Pivot Tables and the Source data in the Excel file. Everything works fine.

When I change the name of the Excel file or copy the file, I get an error because all Pivot Tables don't automatically update.

How can I do to correct this ?

I am working with Excel 2016. Some of my colleagues that uses Excel 2010 also seem to have this issue.

Thanks

Nicola

 

[nicolassido34]

To be more precise, the issue I am having is related to Pivot Table source file not updating with the new Excel file name.

For example for a Pivot Table in the "Resources2-Calc" tab, I get the following error : Can't Open Pivot Table Source File '[Dashboard-MCT.xlsm]Resources2-Calc'. (Dashboard-MCT is my old Excel file name).