I have Windows XP and Excel 2002 SP3, I have go into EditLinksStartup
Prompt and selected the radio button for Don't display the alert and update
links. However everytime I open this workbook I am still asked if I want to
Update.

Why is this?

I'm guessing here, but if you have links to data sources other than
Excel workbooks (e.g. real-time data links) then I think they are not
covered by that startup prompt.

What link sources do you see in the Edit / Links dialog?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Source Type Update Status
Inventory Status.xls Worksheet A Unknown

When prompted I did click to update the link, both of these files are also
in the same folder...???

"Bill Manville" wrote:

I'm guessing here, but if you have links to data sources other than
Excel workbooks (e.g. real-time data links) then I think they are not
covered by that startup prompt.

What link sources do you see in the Edit / Links dialog?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Strange.

You have checked that Edit / Links / Startup Prompt is what you thought
you had set it to (don't display and do update)?

If you wish, email me the file (Bill_Manville @ compuserve.com without
the spaces) and I will see if I can reproduce the behaviour and
determine a cause.


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Hi Steven

Thanks for sending the files.
Like you, I had believed what this Startup Prompt option said on the
label. Seems we were both wrong.

I found an MSKB article
http://support.microsoft.com/default...b;en-us;826921
which indicates (rather unclearly) that with this option, the dialog is
only suppressed if the user has de-selected
Tools / Options / Edit / Ask to update automatic links

It seems to me that this makes this option behave identically to the
default "Let users choose to display the alert or not":
If the tools / options setting is ticked the user gets an update links
dialog and if not then the links are updated automatically with no
dialog.

I have raised the question with Microsoft since I feel it cannot be by
design that there are 2 options with the same behaviour.

Meanwhile, I suggest you choose the second option "Don't display the
dialog and don't update links". Then, if your workbook can contain
macros, have a Workbook_Open macro that does the updating:

Private Sub Workbook_Open()
Dim vLinks, vLink
vLinks = ThisWorkbook.LinkSources(xlExcelLinks)
For Each vLink In vLinks
ThisWorkbook.UpdateLink(vLink, xlExcelLinks)
Next
End Sub

Bill Manville
MVP Microsoft Excel
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Bill,

Great research and response. I may consider adding the code to the Open of
the workbook. This initial post came about because I was opening this file
from Access to add some information into it. From Access I would have the
window not be visible, however the pop up was causing that action to fail. I
later realized that I needed to amend my calling code from Access to read:

xlsApp.Workbooks.Open strNetworkCO, UpdateLinks:=3

With the UpdateLinks set to 3 this would update without prompting if coming
from another application. It was just strange that using that option we
first begin discussing that it wouldn't have suppressed this dialog.

Again great information here and I will not forget this one.

-Steve


"Bill Manville" wrote:

Hi Steven

Thanks for sending the files.
Like you, I had believed what this Startup Prompt option said on the
label. Seems we were both wrong.

I found an MSKB article
http://support.microsoft.com/default...b;en-us;826921
which indicates (rather unclearly) that with this option, the dialog is
only suppressed if the user has de-selected
Tools / Options / Edit / Ask to update automatic links

It seems to me that this makes this option behave identically to the
default "Let users choose to display the alert or not":
If the tools / options setting is ticked the user gets an update links
dialog and if not then the links are updated automatically with no
dialog.

I have raised the question with Microsoft since I feel it cannot be by
design that there are 2 options with the same behaviour.

Meanwhile, I suggest you choose the second option "Don't display the
dialog and don't update links". Then, if your workbook can contain
macros, have a Workbook_Open macro that does the updating:

Private Sub Workbook_Open()
Dim vLinks, vLink
vLinks = ThisWorkbook.LinkSources(xlExcelLinks)
For Each vLink In vLinks
ThisWorkbook.UpdateLink(vLink, xlExcelLinks)
Next
End Sub

Bill Manville
MVP Microsoft Excel
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup