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