Hi, I would like some help with refreshing data in excel
I have created a dashboard for monthly reports.
I make a copy from the last month report to create the next report which has worked for a few months but now I get a sign saying Reference isn't valid
and One or more connections didn't refresh or the refresh operation was canceled...
How can I fix this? Sample dashboard and data attached.
Regards,
Roxana
Hi Roxana,
There was no file attached, but my guess is that your file had PivotTables in it and the ranges referenced by the PivotTables need updating to the new file name. This is a known PivotTable issue.
Mynda
Hi Mynda,
Thank You for your answer I sent the file to support
Could you please guide me on how to refresh the Pivot Tables?
Thank You in Advance
Regards,
Roxana
Hi Roxana,
Go to Data tab, Connections section, and click on Connections button. Select WorkbookConnectionTable1 and choose Remove, this is the one that fails, it's a table with 6 rows that was added to data model and deleed from sheet I think.
Hi Catalin,
Thank You so much! problem solved!
Roxana
