Posted to microsoft.public.excel.programming

Paul Dennis Paul Dennis is offline

external usenet poster

Posts: 51

PivotCache.Refresh

Can anyone help with this error please, when I run the following statement in
my macro

ActiveSheet.PivotTables("DataPivot").PivotCache.Re fresh

Runtime error 1004

Unable to get the PivotTable properties of the worksheet task

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
Add PivitField to PivotCache	Simon Shaw	Excel Programming	1	September 26th 06 02:51 AM
PivotCache	T.	Excel Programming	1	August 18th 06 10:17 PM
Pivotcache	Pivot Table Pete	Excel Programming	1	August 5th 06 12:38 PM
Update PivotCache	Staaan	Excel Programming	0	November 30th 05 10:49 AM
RefreshTable vs PivotCache.Refresh	Paul Lautman	Excel Programming	0	September 24th 04 04:17 PM

All times are GMT +1. The time now is 01:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us