How can I check if I’ve got different pivot caches in my workbook?

Okay, I know that I should generally avoid having multiple caches in a workbook... But I've got some Excel reports I inherited from a colleague... How can I check if they're duplicating caches? The easiest way would be to check the source data of each pivot table.┬áThis, however, may not be the quickest option, especially … Continue reading How can I check if I’ve got different pivot caches in my workbook?