linking to a file on a network

  • Thread starter Thread starter tjb
  • Start date Start date
T

tjb

I have a cell in one workbook that is linked to another
cell in a different workbook located on a public network
folder.

When the user opens the file containing the link, Excel
asks the user to update or don't update the linked cell.

Is there a way to automatically update the link without
asking the user? I have a feeling this is a security
feature that can't be overriden but any help would be
appreciated.
 
You can toggle the setting (user by user, though) via:

Tools|Options|Edit Tab.
There's a checkmark for "ask to update automatic links"

But this means that you suppress the question--the links still get updated.

This setting is for the individual user--and affects all their workbooks.

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.

And xl2002 added an option that allows you to have more control:
Edit|links|startup prompt button.
check the "don't display the alert and update links"
 
Back
Top