How can I permanently delete data from a PIVOT TABLE?

[NeilK]

Hi,

Can anyone help me as in how to delete data from a pivot table in Excel? I'm creating the pivot table from an Access data table and have tried refreshing the pivot table in Excel using an empty Access table however the pivot table keeps the "history" data.

For example, if one of my columns in the pivot table is Product Description, if i click on the drop down for that column all of the historical data remains.

Any help would be greatly appreciated.

Thanks! Neil

 

[KellyW]

Hi,

i think that you need to delete the excel sheet that holds your Pivot table report.
KellyW