Archive of Mr Excel Message Board

Back to Pivot Tables in Excel archive index
Back to archive home

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

Re: converting pivot tables to spreadsheets

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

Re: converting pivot tables to spreadsheets

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.