Refresh Pivot Tables Automatically

[Greg]

I know that in the Pivot Table Options you can
check 'Refresh on Open', which will allow you to refresh
all pivot tables when you close the file and reopen it.

I have a workbook with multiple pivot tables and I'd like
to have them all refresh at the click of a button when I
make changes to the underlying data (without having to
close and reopen the file). I tried recording a macro,
but got an error when running it. Is there a way to make
this work?

Thx!

 

[Frank Kabel]

Hi
use the following macro
Sub Refresh_Pivot()

Dim ws As Worksheet
Dim pt As PivotTable

On Error Resume Next
For Each ws In ActiveWorkbook.Worksheets
For Each pt In ws.PivotTables
pt.RefreshTable
Next
Next
End Sub

 

[Dave Peterson]

You may want to look at refreshall in VBA's help:

ThisWorkbook.RefreshAll