Excel 2007 OLAP PivotTable Tips
User Rating: / 1
PoorBest 
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.
  1. 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.
  2. Use conditional formatting within the cube. Excel, will honor these cell formatting options by default.
  3. 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...

 

Tags: article, excel, tip
 

XL Cubed