View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Startup prompt - Update links

If you tell excel that you want to be asked before updating links, then excel
will respect that setting:

Tools|options|edit tab
Uncheck "Ask to update automatic links"

This is a user-by-user setting--not a workbook setting.

"Horatio J. Bilge" wrote:

I am trying to remove the startup prompt that asks if I want to update links
to external workbooks (I want the links to update automatically for this
workbook).

I clicked on Edit - Links...
I clicked "Startup Prompt..."
I selected "Don't display the alert and update links"
I clicked OK, and closed the dialog box.

When I try reopening the workbook, the prompt still comes up.


--

Dave Peterson