Re: Delete PivotCache
- From: "Tom Ogilvy" <twogilvy@xxxxxxx>
- Date: Tue, 21 Jun 2005 16:03:15 -0400
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" <sorin.constantin@xxxxxxxxx> wrote in message
news:1119376513.608474.269570@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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
>
.
- References:
- Delete PivotCache
- From: sorin
- Delete PivotCache
- Prev by Date: Re: Send Mail Script Help
- Next by Date: Re: Save from a template to XLS only visible sheets
- Previous by thread: Delete PivotCache
- Next by thread: How do I use the AutoSum?
- Index(es):
Relevant Pages
|
