ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Outside Data Sources (https://www.excelbanter.com/excel-programming/322149-outside-data-sources.html)

Bill

Outside Data Sources
 
When I open my workbook I get a pop-up message box with the following message.

This workbook contains links to other data sources thus I am provided three
options of update, Don't Update, or Help. Is there VB code I input that will
update the workbook automatically.

Charles Harmon

Outside Data Sources
 
Bill,

I think this will stop the prompt and allow the update to proceed. Select
Tool, Option, View. Look for "Ask to Update" if the check box is selected
unselect it.

Charles
"Bill" wrote in message
...
When I open my workbook I get a pop-up message box with the following
message.

This workbook contains links to other data sources thus I am provided
three
options of update, Don't Update, or Help. Is there VB code I input that
will
update the workbook automatically.




Bill

Outside Data Sources
 
Charles

Thanks. That appears to have worked.

Bill

"Charles Harmon" wrote:

Bill,

I think this will stop the prompt and allow the update to proceed. Select
Tool, Option, View. Look for "Ask to Update" if the check box is selected
unselect it.

Charles
"Bill" wrote in message
...
When I open my workbook I get a pop-up message box with the following
message.

This workbook contains links to other data sources thus I am provided
three
options of update, Don't Update, or Help. Is there VB code I input that
will
update the workbook automatically.






All times are GMT +1. The time now is 07:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com