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?

5 Default Pivot Table Settings You Should Reset

You know that annoying bit when every time you’ve refreshed your pivot table, you also need to re-size your columns?  This is how you can prevent it from happening Do you see #DIV/0! errors in your pivot tables? No worries, Excel is just reminding you that you cannot divide by 0 Tip: You can also type the value/text you … Continue reading 5 Default Pivot Table Settings You Should Reset