Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
message when saving workbook
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
message when saving workbook
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
message when saving workbook
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Message when saving a worksheet | New Users to Excel | |||
Saving workspaces (.xlw) Get error message | Excel Worksheet Functions | |||
error message when saving excel workbook | Excel Discussion (Misc queries) | |||
.csv incompatible message after saving | Excel Worksheet Functions | |||
warning or message before saving spreadsheet | Excel Worksheet Functions |