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

nicolassido34

New Member
Joined
Jul 10, 2016
Messages
2
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
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

nicolassido34

New Member
Joined
Jul 10, 2016
Messages
2
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).
 

Watch MrExcel Video

Forum statistics

Threads
1,119,297
Messages
5,577,245
Members
412,777
Latest member
MrGray
Top