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)

"DaveWallace" wrote in message
...
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

HTH,
Thanks for the suggestion.
I tried it , but the message still comes up.
Any further ideas?
Thanks!

-Dave

-----Original Message-----
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)

"DaveWallace" wrote in
message
...
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


.