try this:
Application.DisplayAlerts = False
....your table refresh code
Application.DisplayAlerts = True

Untested with a pivot table, so your mileage may vary...

"Shell" wrote:

In Excell 2000, I have successfully refreshed a pivot table via VBA code.
However at the end of the process I get a Microsoft popup.

PivotTable
ImportD... BoxType Success... OPTSta... OPTSta...
DISCO_... Division Prin Years

These are all the fields in the source data. But how do I, in code,
suppress this popup?

Thanks
--
Shell