How Do I Quickly Export Multiple PivotTables to PowerPoint Slides?

I've got to convert all those pivot tables into slides and it's taking ages! No worries! It's not all doom and gloom!¬† I did write about a similar technique recently. This one is a little bit trickier because you've got to deal with multiple pivot tables per workbook rather than just one based in a … Continue reading How Do I Quickly Export Multiple PivotTables to PowerPoint Slides?

How do I quickly align all my Pivot Tables to the same Pivot Cache?

The check for multiple pivot caches has shown that your workbook has a couple of duplicated ones?   You need to change the source data of all your pivot tables from a dataset stored in your workbook to an ODBC/OLEDB connection? Don't feel like doing it manually? That's completely understandable! As you see above, doing … Continue reading How do I quickly align all my Pivot Tables to the same Pivot Cache?

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?