suppress the message 'refresh operation changed the pivot table'

[peterhine21]

Can i suppress the message 'refresh operation changed the pivot table' wen
refreshing a pivot table. I have a number of files that eacj contain a number
of pivot tables that are connected to external sources. I want to use a macro
to open each file and automatically refresh the pivot tables, save the file
and close it. Because only some of the pivots change in layout the above
message is not displayed for each pivot and therefore it is difficult to
write amacro that cope with the variability

[ADG]

Try putting Application.DisplayAlerts = False before you refresh then rember
to set Application.DisplayAlerts = Ture once your finished
--
Tony Green


"peterhine21" wrote:

> Can i suppress the message 'refresh operation changed the pivot table' wen
> refreshing a pivot table. I have a number of files that eacj contain a number
> of pivot tables that are connected to external sources. I want to use a macro
> to open each file and automatically refresh the pivot tables, save the file
> and close it. Because only some of the pivots change in layout the above
> message is not displayed for each pivot and therefore it is difficult to
> write amacro that cope with the variability

[peterhine21]

spot on - thanks

"ADG" wrote:

> Try putting Application.DisplayAlerts = False before you refresh then rember
> to set Application.DisplayAlerts = Ture once your finished
> --
> Tony Green
>
>
> "peterhine21" wrote:
>
> > Can i suppress the message 'refresh operation changed the pivot table' wen
> > refreshing a pivot table. I have a number of files that eacj contain a number
> > of pivot tables that are connected to external sources. I want to use a macro
> > to open each file and automatically refresh the pivot tables, save the file
> > and close it. Because only some of the pivots change in layout the above
> > message is not displayed for each pivot and therefore it is difficult to
> > write amacro that cope with the variability