MrExcel Publishing
Your One Stop for Excel Tips & Solutions

converting pivot tables to spreadsheets

Posted by jaime gonzalez on January 18, 2002 2:25 PM

can someone remind me how to convert a pivot table to a spreadsheet so that i may manipulate the data as a spreadsheet??
thanks so much

Posted by Barrie Davidson on January 18, 2002 2:40 PM

Select the pivot table, copy, paste|special|values.

Is this what you need?
BarrieBarrie Davidson

Posted by Chris D on January 18, 2002 3:26 PM

Not sure it's what you mean, but you could also double click on the total/total cell (usually bottom right)..... this will open up a new sheet that mirrors the original spreadheet data (in the unlikely occurance that it's been deleted and all you have to work with is the pivot itself

As with Barrie's paste special/values, you get values rather than any original formulae

HTH too