Posted to microsoft.public.excel.programming

Kara

external usenet poster

Posts: 23

PivotCache.Refresh

I was getting the same message. I even tried recording a macro to refresh the
pivot table, but got the same code. It seemed to have worked in Excel 2003
but not in 2007.

I don't have much VBA experience, but when I changed the statement to be,
ActiveSheet.PivotTables("DataPivot").RefreshTable, the macro would continue
to run.

Hope this helps.

Kara

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 02:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us