Deleting Raw Data = Deleting Pivot Tables?

Hi all,

If I have tons of data, and I make pivot tables out of them, can I delete the raw data? The macros I've built only take the information from the pivot charts, not the raw data (on a different sheet, of course), so the question is can I delete the raw data after? It makes the file REALLY heavy, which is why I'm asking... Plus there's stuff there I really don't want people to see if they don't have to.

Thanks!

Yes you can remove the pivotcache if all you want is the values as they appear in the pivot table as it currently appears. If you want to dynamically alter the pivot table (eg by applying a filter on row or page fields) then you must retain the cache.

To remove the cache, copy and paste values over the pivot tables that are created from this cache.

Richard