MrExcel.com - Your One Stop for Excel Tips & Solutions

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

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

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