|
Excel 2007 OLAP PivotTable Tips |
|
Written by Richard Lees
|
|
Saturday, 17 October 2009 14:03 |
|
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.
Read more... |
