ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Chosen not to update links but they are updated anyway. How stop? (https://www.excelbanter.com/excel-discussion-misc-queries/58768-chosen-not-update-links-but-they-updated-anyway-how-stop.html)

Stephen, Generis December 5th 05 05:07 PM

Chosen not to update links but they are updated anyway. How stop?
 
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.

TylerDurden December 21st 05 03:31 PM

Chosen not to update links but they are updated anyway. How stop?
 

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


Stephen, Generis December 21st 05 09:54 PM

Chosen not to update links but they are updated anyway. How st
 
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




All times are GMT +1. The time now is 02:11 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com