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.

Jim Bud wrote:

We are on XP with Office 2003, In Excel 2003 on a file created in Excel 2000
when user attempted to open the attached excel file in Excel 2003, she got
prompt "the workbook contains automatic links to information in another
workbook, do you want to update this workbook with changes made to the other
workbook". No matter she chose "update" or "don't update", the data in
"actual" column will disapper.

Support agent helped her try to disable auto-update.
(http://support.microsoft.com/default...b;en-us;288851). But we
still get prompt and still the same problem.

Suggestions????? Thanks, Jamie

--

Dave Peterson