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?
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?
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?
If Excel is your main play tool, more often than not, you will find yourself analysing data by summarizing it in pivot tables. It is important to make sure that all the pivot tables based on the same dataset also share the same pivot cache. But why would I want to do that? You are … Continue reading Why should I align my Pivot Caches?
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