![]() |
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. |
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. |
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