Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 5th 05, 05:07 PM posted to microsoft.public.excel.misc
Stephen, Generis
 
Posts: n/a
Default 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.

  #2   Report Post  
Old December 21st 05, 03:31 PM posted to microsoft.public.excel.misc
TylerDurden
 
Posts: n/a
Default 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

  #3   Report Post  
Old December 21st 05, 09:54 PM posted to microsoft.public.excel.misc
Stephen, Generis
 
Posts: n/a
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
options to update automatic links Werner Rohrmoser Excel Worksheet Functions 0 November 10th 05 12:58 PM
Prompt to update links Werner Rohrmoser Links and Linking in Excel 0 November 3rd 05 09:47 AM
Update links prompt not wanted neeraj Excel Discussion (Misc queries) 5 September 23rd 05 06:34 PM
can't update links...can't find links GJR3599 Excel Discussion (Misc queries) 1 April 4th 05 04:56 PM
Update Individual Links mikxtr Excel Discussion (Misc queries) 3 January 21st 05 04:24 AM


All times are GMT +1. The time now is 10:05 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017