Pivot Tables - mulitple consolidation ranges

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

Roger Govier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

not your typical Pivot Table Named Range question 7
Creating a Pivot Table using multiple ranges 1
Excel 2010 Slicer Connection / Pivot Table Problem 3
pivot table loosing decimals (vba) 1
Changing Pivot Table Data Source to multiple ranges 1
pivot wizard buttons 2
Help - Consolidation refreshing 7
pivot table calculated field 1

Top