Updating "pivots"

[Guest]

It seams that

ActiveWorkbook.RefreshAll

dos not update pivot tables!

Any hints

 

[Dave Peterson]

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

 

[Roger Govier]

Hi Jens

Try
Sub RefreshAllPivots()
Dim pc As PivotCache
For Each pc In ActiveWorkbook.PivotCaches
pc.Refresh
Next
End Sub