When you open this workbook, you're prompted to update links (if you have that
setting). But if you answer no, you get a bunch of #ref! errors.

In earlier versions of excel, the old values were kept.

If this describes the problem...(from a previous post):

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.



Keith at Sterling wrote:

We would like to upgrade to Excel 2002 or(XP) however we have a huge amount
of excel 97 files that are loaded with Vlookup formulas similar to

=VLOOKUP('F:\Prices-Dec 2004-Master Program\Master Pricing -
Pacesetter.xls'!Joist_Package_2,'F:\Prices-Dec 2004-Master Program\Master
Pricing - Pacesetter.xls'!Prices_To_Change,MATCH('F:\Prices-Dec 2004-Master
Program\Master Pricing - Pacesetter.xls'!Apaloosa_A_IX_Series,'F:\Prices-Dec
2004-Master Program\Master Pricing - Pacesetter.xls'!Model_List,0)+2,FALSE)

When we load on Excel 2002 all our Vlookup results have no answers (I can't
remember the exact symbol) so basically all our 100's of workbooks are
useless.

Our IT guys are stumped and tell me they can find no answer
Has any one had this happen? Help to find a cure would be fantastic. We
would love to upgrade.

Keith, having fun with my new hobby

--

Dave Peterson