Hello
I am having this error pop up in a workbook every time I refresh data because a pivot table I created during development, now deleted, is still referenced and looked for somewhere in the system. I have tried several macros to clear the cache (deleted items etc), but the error persists.
'Cannot open PivotTable source file ...X'.
How do I make Excel forget this ever existed? It's not even used anywhere in the current version of the file.
Thanks
I am having this error pop up in a workbook every time I refresh data because a pivot table I created during development, now deleted, is still referenced and looked for somewhere in the system. I have tried several macros to clear the cache (deleted items etc), but the error persists.
'Cannot open PivotTable source file ...X'.
How do I make Excel forget this ever existed? It's not even used anywhere in the current version of the file.
Thanks
