when i select dont update I get #REF!

M

mmollat

When I select dont update sheet, previous version should my figures. With 2k3
figure change to #REF!

I'm puzzled, how do i prevent this from happening?
 
D

Dave Peterson

xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links
prompt, the existing values are kept. In xl2002+, you get those errors.

Jim Rech posted a registry tweak:
http://groups.google.com/[email protected]

Maybe it'll work ok for you.
 
D

dinomium

I tried to do the same fix for the same error and was not sucessful! I do not
have the same registry entrys for Office 9.0 (no options folder). I tried to
use the DWORD key in Options under Office 11 and in just Office 9.0 both with
no effect...
Anybody else have a fix to try?
thanks,
 
Top