Posted to microsoft.public.excel.programming

external usenet poster

Posts: 6

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I add an item to a PivotCache with VBA?	John Brock	Excel Discussion (Misc queries)	4	June 16th 08 01:00 PM
RefreshTable vs PivotCache.Refresh	Paul Lautman	Excel Programming	0	September 24th 04 04:17 PM
Set a PivotCache as the results of a query	tod	Excel Programming	2	February 16th 04 05:41 PM
Reading PivotCache for Pivot Table	Adam[_9_]	Excel Programming	0	January 21st 04 10:06 PM
Changing PivotCache SQL Database	John Michl[_2_]	Excel Programming	0	July 15th 03 09:45 PM

All times are GMT +1. The time now is 07:03 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us