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

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 source file don't automatically update.

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).

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

Nicolas