#VALUE! show up on "non-updated" links to another sheet
 

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.

#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