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