Excel lets the users override any settings the developer sets.

If you can convince them to change that "ask to update" prompt, then you'll be
set. If the user chooses to keep that checked, then your Edit|Links choice are
just ignored.

One way around it is to build another workbook that opens the workbooks the way
you want.

The dummy workbook would contain a macro like this:

Kind of like:

Option Explicit
Sub auto_open()
Workbooks.Open Filename:="c:\my documents\excel\book2.xls", UpdateLinks:=1
ThisWorkbook.Close savechanges:=False
End Sub

Then you open the dummy workbook and the links will be refreshed.
(read about that UpdateLinks argument in VBA's help.)


neeraj wrote:

I am posting a few files sayb File A and File B (Excel 2003) on a network
drive. These files are password protected and are linked to each other where
File A is the source file for File B. To suppress the prompt to update when I
open File B, I went into Tools-Options-Edit and unchecked the 'Ask to update
automatic links'. This has stopped prompting me for updating all files
including these 2 files but I understand this is good only for my computer.I
would also like all users of these files on the network not to be prompted
for updating but that they open automatically File B with updated values. For
this,I attempted going into Startup Prompt of Edit Links...and selected the
option 'Dont display the alert and update links'. I have tested this on my
own computer : It works fine if 'ask to update automatic links'...is cleared
but when it is checked, it again starts asking me for updating links even
when the startup prompt says 'dont display alert and update links'. I am a
bit confused about links now... Please help...Thanks

--

Dave Peterson