I am trying to open a worksheet with links to another program that I do
not have. As such, I do not want the links to automatically update when
I open the workbook. Even though I select "do not update", the links
still update and I get a bunch of error messages in all of the cells.
Any ideas? It is driving me nuts!!


--
mcarrington
------------------------------------------------------------------------
mcarrington's Profile: http://www.excelforum.com/member.php...o&userid=21641
View this thread: http://www.excelforum.com/showthread...hreadid=469557

One possibility is to check for a VBA event handler in the workbook (such as
Workbook_Open) that is trying to automatically update the links. I believe
this event code would run after Excel asks whether or not you want to update
links (which would explain why it is trying to update links even after you
say no).

With the workbook open, hit Alt+F11 and find the ThisWorkbook module in the
project explorer. Check for Workbook_Open macro.

"mcarrington" wrote:


I am trying to open a worksheet with links to another program that I do
not have. As such, I do not want the links to automatically update when
I open the workbook. Even though I select "do not update", the links
still update and I get a bunch of error messages in all of the cells.
Any ideas? It is driving me nuts!!


--
mcarrington
------------------------------------------------------------------------
mcarrington's Profile: http://www.excelforum.com/member.php...o&userid=21641
View this thread: http://www.excelforum.com/showthread...hreadid=469557