when i select dont update I get #REF!
 

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?

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/groups?thre...GP11.phx .gbl

Maybe it'll work ok for you.

mmollat wrote:

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?

--

Dave Peterson

You are the man! That worked like a charm. Thanks for the quick reply!

"Dave Peterson" wrote:

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/groups?thre...GP11.phx .gbl

Maybe it'll work ok for you.

mmollat wrote:

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?

--

Dave Peterson

Jim is very smart!

I'm sure he's happy you got it working.

mmollat wrote:

You are the man! That worked like a charm. Thanks for the quick reply!

"Dave Peterson" wrote:

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/groups?thre...GP11.phx .gbl

Maybe it'll work ok for you.

mmollat wrote:

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?

--

Dave Peterson


--

Dave Peterson

when i select dont update I get #REF!
 

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,
--
Dino



"mmollat" wrote:

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?