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.

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" <Bill@discussions.microsoft.com> wrote in message
news:984E1197-9211-4F49-B17A-3F6808788F63@microsoft.com...
> 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

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" <Bill@discussions.microsoft.com> wrote in message
> news:984E1197-9211-4F49-B17A-3F6808788F63@microsoft.com...
> > 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.
>
>
>