Robert,

Perhaps it is because two or more of your pivot tables share a data table.
Updating one pivot table will update all pivot tables based on that data
table, and perhaps cause a cascade effect (though here I am just guessing -
I rarely use more than one data table in a workbook, and having the pivot
tables update prematurely isn't a big deal).

If it is causing you problems, you might want to split your workbook up....

Bernie


"pepenacho" wrote in message
...
Bernie:

All the stuff worked. There seems to be one minor subtle outcome with this
sub. I have 4 tables in my Excel file and about 8 Work Sheets that have
PivotTables, which feed from the tables.

In each Work Sheet I have a button that calls a procedure in a Module
called
RefreshAllPivots

Sometimes this seems to refresh all PivotTables in all the Work Sheets,
and
sometimes in just that one specific one. What's the catch, I
trouble-shooted
this to kingdom come and can't figure it out?

Sub RefreshAllPivots()
Dim myPT As PivotTable
For Each myPT In ActiveSheet.PivotTables
myPT.PivotCache.Refresh
Next
End Sub


Thanks,
Robert