Using Excel 2003 but linked to spreadsheets created in 2000. When asked if I
wanted to update links, I said 'no' because I wanted to take figures and
break links to some linked spreadsheets. But then spreadsheet appears to
update anyway, replacing figures I can see (and want) and giving me 'Value'
errors instead.

There's a section in Tool-Options-Edit that allows for universal
updating of links ("Ask to update automatic links). If this is
unchecked, that's probably why.


--
TylerDurden
------------------------------------------------------------------------
TylerDurden's Profile: http://www.excelforum.com/member.php...o&userid=17638
View this thread: http://www.excelforum.com/showthread...hreadid=490796

I _want_ to be asked if I want to update and this is what it's doing. But
when I say 'no' to update, it's doing it anyway. Box you refer to is checked.

"TylerDurden" wrote:


There's a section in Tool-Options-Edit that allows for universal
updating of links ("Ask to update automatic links). If this is
unchecked, that's probably why.


--
TylerDurden
------------------------------------------------------------------------
TylerDurden's Profile: http://www.excelforum.com/member.php...o&userid=17638
View this thread: http://www.excelforum.com/showthread...hreadid=490796