Updating "pivots"

It seams that

ActiveWorkbook.RefreshAll

dos not update pivot tables!

Any hints

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
news:[email protected]...
> 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