Compatability of Excel 2000 vs Excel 2003

D

deb

When open up the attached file(from someone who has Excel 2000) it shows numbers and states do you want me to update or don't update. If I chose either of these options, values appears on the report
 
D

Dave Peterson

xl2002 (and I'd bet xl2003) like to recalculate workbooks that were created in
earlier versions--as soon as you open them.

If there are links that can't be refreshed, you'll get those errors.

You could ask the xl2k user to convert those links to values (a copy of the
workbook--not the original!).

Jim Rech posted a registry tweak:
http://groups.google.com/[email protected]

He posted the tweak for xl2k (\9.0\ in the post).

I'm not sure if it'll work in xl2003 (you'd use \11.0\)

You'll see what that means when you follow the link to Jim's post.
 
Top