I have been searching through posts and cannot find
a consistent answer to this question. I am running
Excel 2003 and I would like to remove or disable
the "update links" prompt when the file is open.

I have gone to Edit -> Links -> Start-up Prompt ->
and checked:
"Don't display the alert and update links"

which is exactly what I want to happen when the file
is opened by any of my multiple users, however the
alert comes up anyway.

Does anyone have any advise as to how to
disable this prompt?

On the menu bar, Tools>Options>Edit tab>Uncheck "Ask to Update Links"

"Opal" wrote:

> I have been searching through posts and cannot find
> a consistent answer to this question. I am running
> Excel 2003 and I would like to remove or disable
> the "update links" prompt when the file is open.
>
> I have gone to Edit -> Links -> Start-up Prompt ->
> and checked:
> "Don't display the alert and update links"
>
> which is exactly what I want to happen when the file
> is opened by any of my multiple users, however the
> alert comes up anyway.
>
> Does anyone have any advise as to how to
> disable this prompt?
>

That setting is for your system only. It would not affect another user's
system. They would have to adjust their own systems to disable the message.

"Opal" wrote:

> I have been searching through posts and cannot find
> a consistent answer to this question. I am running
> Excel 2003 and I would like to remove or disable
> the "update links" prompt when the file is open.
>
> I have gone to Edit -> Links -> Start-up Prompt ->
> and checked:
> "Don't display the alert and update links"
>
> which is exactly what I want to happen when the file
> is opened by any of my multiple users, however the
> alert comes up anyway.
>
> Does anyone have any advise as to how to
> disable this prompt?
>

You could, however, put a line in the Workbook.Open event like:

Application.AskToUpdateLinks = False

which would turn it off for them.

"Opal" wrote:

> I have been searching through posts and cannot find
> a consistent answer to this question. I am running
> Excel 2003 and I would like to remove or disable
> the "update links" prompt when the file is open.
>
> I have gone to Edit -> Links -> Start-up Prompt ->
> and checked:
> "Don't display the alert and update links"
>
> which is exactly what I want to happen when the file
> is opened by any of my multiple users, however the
> alert comes up anyway.
>
> Does anyone have any advise as to how to
> disable this prompt?
>

Put this in the ThisWorkbook code module. In the VBE Project
Window, right click ThisWorkbook and choose view code. Copy
and paste this into that code window.

If you already have
a Workbook Open event code, then just add the middle line of
this code into the existing code.

Private Sub Workbook_Open()
Application.AskToUpdateLinks = False
End sub





"JLGWhiz" wrote:

> You could, however, put a line in the Workbook.Open event like:
>
> Application.AskToUpdateLinks = False
>
> which would turn it off for them.
>
> "Opal" wrote:
>
> > I have been searching through posts and cannot find
> > a consistent answer to this question. I am running
> > Excel 2003 and I would like to remove or disable
> > the "update links" prompt when the file is open.
> >
> > I have gone to Edit -> Links -> Start-up Prompt ->
> > and checked:
> > "Don't display the alert and update links"
> >
> > which is exactly what I want to happen when the file
> > is opened by any of my multiple users, however the
> > alert comes up anyway.
> >
> > Does anyone have any advise as to how to
> > disable this prompt?
> >

Thank you JLGWhiz,

That last post was exactly what I needed. I couldn't use
the Tools ->Options....as I have over 100 people accessing
this file and we need the prompt working for other files,
so I needed this to work on this file only.