Pivot Tables - mulitple consolidation ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi - I created a spreadsheet in Excel 2003 that contained a pivot table. The
table was created using the wizard - I am using it to 'undo' a two way table
so when I created it I chose
Multiple Consolidation Ranges
I will create field pages myself
I specified the range of cells
Left only Sum of Value in the pivot table - on double clicking this I then
get a one way table of my data.

However, this is not working in 2007 and I have been unable to re-create the
pivot table as the wizard doesn't give the same options - does anyone know
how I can re-create in the new version?

Many thanks.
 
Hi

To invoke the wizard in XL2007, and get to the point where you can choose
Multiple Consolidation ranges, use the shortcut Alt D P
 
Back
Top