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