software

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(quot;Pivot1quot;) _
.PivotCache.BackgroundQuery = TrueJens wrote:
gt;
gt; It seams that
gt;
gt; ActiveWorkbook.RefreshAll
gt;
gt; dos not update pivot tables!
gt;
gt; 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 Govierquot;Jensquot; lt;Jens @discussions.microsoft.comgt; wrote in message
...
gt; It seams that
gt;
gt; ActiveWorkbook.RefreshAll
gt;
gt; dos not update pivot tables!
gt;
gt; Any hints