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.