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 for you.

Nick Ersdown wrote:

Hi,

My client has a spreadsheet which works fine in Excel 2000 but when opened
with Excel 2003 it populates the pages with #VALUE! and the best I can tell
is that the problem is with the following formulas.

Can anyone advise if they have seen this before. I am unable to post their
file but this is the code that I think is a bit suspect.

=IF(ISERROR(VLOOKUP(B14,'C:\Documents and Settings\User\My Documents\[Price
List 040301.xls]Items'!$A:$M,11,FALSE))=TRUE,"",VLOOKUP(B14,'C:\Do cuments
and Settings\User\My Documents\[Price List
040301.xls]Items'!$A:$M,11,FALSE))

Many thanks,

Nick Ersdown

--

Dave Peterson