Delete PivotCache
 

Hi all,

I'd like to create a macro to easily delete a Pivot table.

I noticed that ws.PivotTables(i).TableRange2.Clear eliminates the
pivottable from worksheet and collection while pivotchache object still
remains in the workbook.

Any ideas?

Best regards

Delete PivotCache
 

When all pivottables that depend on the cache are eliminated, then the cache
will be cleared when you save the workbook.

--
Regards,
Tom Ogilvy


"sorin" wrote in message
oups.com...
Hi all,

I'd like to create a macro to easily delete a Pivot table.

I noticed that ws.PivotTables(i).TableRange2.Clear eliminates the
pivottable from worksheet and collection while pivotchache object still
remains in the workbook.

Any ideas?

Best regards