Report Portal

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.
  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.


Tags: excel, tip


2007-2015 VidasSoft Systems Inc.