Links

[ceemo]

I have a cell linked to another workbook and when i open the book it
promts me on whether i want to update the linked cell. I have changed
the links menu to 'Dont diplay the alert and update links' but i still
get a pop up. I would like the workbook to open without th pop up.

 

[Dave Peterson]

There's another setting that you should toggle:

Tools|Options|edit tab|uncheck "Ask to update automatic links"

If you're sharing the workbook with others and expect the same behavior, you'll
want to know that this is a user-by-user setting. Each user would have to
toggle this off. And it affects all workbooks opened by the user, too.

 

[ceemo]

Thanks for the reply.


Does anyone know of any other way around this as other users will b
using this workbook. Perhaps something coded in VB ?

 

[Dave Peterson]

If you want more control:
Try creating a dummy workbook whose only purpose is to open the original
workbook with links updated:

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.)

Then have the users open the dummy workbook.