suppress the message 'refresh operation changed the pivot table'

P

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
 
A

ADG

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

peterhine21

spot on - thanks

ADG said:
Try putting Application.DisplayAlerts = False before you refresh then rember
to set Application.DisplayAlerts = Ture once your finished
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top