Why should I align my Pivot Caches?

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?

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

How Do I Quickly Get Rid of Unused Range with VBA?

What is unused range? The best way to explain it would probably be "a residual redundant space" - Excel simply remembers the last cell in which you ever had data even after that data is long gone. How do I check if my workbook has unused ranges? Click on a random cell in your sheet … Continue reading How Do I Quickly Get Rid of Unused Range with VBA?