Excel 2007 OLAP PivotTable Tips
I am a great fan of Excel as an ad hoc cube browser, even though it lacks a few features I would like to see. Many people don't appreciate some of the functionality available within Excel. Here are a few of my favourite features.
- Right click somewhere in the pivottable and select PivotTable Options. Get familiar with all the options. My favorites are Refresh data when opening the file and disabling row/column totals.
- Use conditional formatting within the cube. Excel, will honor these cell formatting options by default.
- Use Excel's conditional formatting on top of number formatting. Excel will hold the conditional formatting until you change what's on rows.