Hi John,

I have a workbook where I have created numerous pivot tables, some of which have been modified a few times through table updates whereas other pivot tables have been deleted (where they were no longer relevant) as I have progressed the data analyses in the workbook. I have created my pivot tables using the ALT+N+V shortcut but I have also used the old version (ALT+D+P) shortcut to create a separate cache so grouping data (eg dates) would not translate to adjacent pivot tables derived from the same cache. I have now discovered that I have 17 pivot caches in my workbook even though i now don't have anywhere near 17 pivot tables remaining.

1. How do I identify the relevant pivot caches and delete the redundant caches to make the workbook run and update faster? (currently waiting around 1-5 secs for pivot table updates from data table changes).

I also have issues with links to previous data sources that are slowing down the workbook performance as well. I have found a way to un-link saving from other external data sources for each pivot table, but with little affect.

2. I am currently trying to recreate a pivot table from a new table data source with extended data rows (replaced the previous table) but the pivot table still refers to the previous table data even though I have deleted this previous data source from the file. I have been saving the workbook each day by an updated date in the file name as a method of file backup should the current file become corrupted. How do I ensure there are no source data links to old files so the new pivot table will refer to the current (newly created) extended data table?

Any help would be most appreciated - thanks!

Cheers,

Hans