Thread: #VALUE! show up on "non-updated" links to another sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default #VALUE! show up on "non-updated" links to another sheet
Jim Rech posted a registry tweak:
http://groups.google.com/groups?thre...GP11.phx .gbl

Absolute0 wrote:

I have a sheet made from Excel 2000. It has links to other sheets. When I
open it in Excel 2003, it ask if I want to update from links. I choose don't
update and it's supposed to show an old value. What it shows though is
#VALUE!. If opened in Excel 2000 it's fine showing an old value. Can this be
fixed? Thanks.

--

Dave Peterson
Reply With QuoteReply With Quote