Links
 

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.


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=548628

Links
 

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 wrote:

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.

--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=548628

--

Dave Peterson

Links
 

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 ?

--
ceem
-----------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...fo&userid=1065
View this thread: http://www.excelforum.com/showthread.php?threadid=54862

Links
 

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.



ceemo wrote:

Thanks for the reply.

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

--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=548628

--

Dave Peterson