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
Chris
