message when saving workbook

  • Thread starter Thread starter DaveWallace
  • Start date Start date
D

DaveWallace

When I save my workbook - which has a pivot table - I get
the message "All pending GetData or RefreshDate commands
have been completed".
I need to update and save this workbook via VBA, so I
can't have that message popping up, preventing the
workbook from being saved.
How do I let Excel know that the workbook is in fact ready
to save and close?
Thanks for your help!!!

-Dave
 
Dave,

Don't use pivot tables myself, but try adding

Application.DisplayAlerts = False

before your code, and reset at the end.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
HTH,
Thanks for the suggestion.
I tried it , but the message still comes up.
Any further ideas?
Thanks!

-Dave
 
Back
Top