Archive of Mr Excel Message Board

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

Clearing a piviot table

Posted by Phil on July 19, 2001 3:28 PM

Hello all,

Once you use the "Save data with spreadsheet" option in a pivot table in Excel 97, how does one clear out the data? I no longer want the 2000 data in there, only data for 2001. Changing the data parameter in the query just appends '01 data to the existing '00.

Thanks,

Phil

Re: Clearing a piviot table

Posted by Mark W. on July 20, 2001 6:00 AM

You'll need to either Hide 2000 data or create
a new PivotTable.

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.