Updating "pivots"
It seams that
ActiveWorkbook.RefreshAll dos not update pivot tables! Any hints |
Updating "pivots"
You sure.
VBA's help does have this remark: Remarks Objects that have the BackgroundQuery property set to True are refreshed in the background. And if you click on BackgroundQuery, you'll see this sample code: Worksheets(1).PivotTables("Pivot1") _ .PivotCache.BackgroundQuery = True Jens wrote: It seams that ActiveWorkbook.RefreshAll dos not update pivot tables! Any hints -- Dave Peterson |
Updating "pivots"
Hi Jens
Try Sub RefreshAllPivots() Dim pc As PivotCache For Each pc In ActiveWorkbook.PivotCaches pc.Refresh Next End Sub -- Regards Roger Govier "Jens" <Jens @discussions.microsoft.com wrote in message ... It seams that ActiveWorkbook.RefreshAll dos not update pivot tables! Any hints |
All times are GMT +1. The time now is 11:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com