Pivot Table "Refresh" ... How?

[Ken]

Excel 2000 ... I am new to use of Pivot Tables ... that
said ... I have 42,000 records on Source TabSheet ... from
this I created 12 Pivot Tables.

Now ... If I change the Source Data ... Do I then need to
individually "Refresh" all 12 Pivot Tables ... or ... can
I set to have all 12 Pivot Tables update at once ...
or ... can I set Pivot Tables to update automatically when
Source Data changes?

Note: I spent some time in the 113 items found in HELP
under "Pivot Tables" in effort to find help on how/when
to "Refresh" Pivot Table data, but did not happen to find
specifics.

What is best way to "Refresh" ... Please advise ...

Thanks ... Kha

 

[BrianB]

I do not know how to do this without a macro. Copy/Paste the followin
into a macro sheet and attach to a button :-

'------------------------------------------------------
Sub REFRESH_ALL()
ActiveWorkbook.RefreshAll
End Sub
'--------------------------------------------------------

 

[Frank Kabel]

Hi
one way:
sub refresh_pivot()
ActiveWorkbook.RefreshAll
End Sub


or another way
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

 

[Jason]

You can either have the pivot table toolbar on the
screen, which I think takes up a lot of space, or you can
right mouse click on any pivot table and click refresh.
I do not know of a way to refresh all of them at one
time, though I am still a little green on pivot tables.

Jason

 

[Ken]

Frank ... What would be the difference? ... Thanks ... Kha

 

[Frank Kabel]

Hi Ken
no difference just two ways