Updating "pivots"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jens - 21 Jan 2006 22:09 GMT

It seams that

ActiveWorkbook.RefreshAll

dos not update pivot tables!

Any hints

Reply to this Message

Dave Peterson - 21 Jan 2006 22:36 GMT

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

> It seams that
>
[quoted text clipped - 3 lines]
>
> Any hints

Signature

Dave Peterson

Reply to this Message

Roger Govier - 21 Jan 2006 22:38 GMT

Hi Jens

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

Signature

Regards

Roger Govier

> It seams that
>
[quoted text clipped - 3 lines]
>
> Any hints

Reply to this Message