Can you post the code to help diagnosis?

--
If this is the answer you hoped for please remember to click the yes button
below...

Kind regards

Rik


"Shell" wrote:

This does NOT work
--
Shell


"JLatham" wrote:

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