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