G Guest Jan 21, 2006 #1 It seams that ActiveWorkbook.RefreshAll dos not update pivot tables! Any hints
D Dave Peterson Jan 21, 2006 #2 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
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
R Roger Govier Jan 21, 2006 #3 Hi Jens Try Sub RefreshAllPivots() Dim pc As PivotCache For Each pc In ActiveWorkbook.PivotCaches pc.Refresh Next End Sub
Hi Jens Try Sub RefreshAllPivots() Dim pc As PivotCache For Each pc In ActiveWorkbook.PivotCaches pc.Refresh Next End Sub
