It seams that

ActiveWorkbook.RefreshAll

dos not update pivot tables!

Any hints

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

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