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
Bookmarks