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?


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

That other program is another excel workbook, right?????


xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links
prompt, the existing values are kept. In xl2002+, you get those errors.

Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

Maybe it'll work for you.

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?

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

--

Dave Peterson

I am opening up a workbook with bloomberg links, but i don't have
bloomberg.


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

I've never used bloomberg.

Sorry,


mcarrington wrote:

I am opening up a workbook with bloomberg links, but i don't have
bloomberg.

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

--

Dave Peterson