General discussion

Locked

Opening Excel 97 worksheet in Excel 2002

By pfoley ·
I support some users that use an Excel worksheet created in Excel 97. This worksheet is linked to a number of other worksheets created in Excel 97 via SUMIF functions. When the worksheet is opened in Excel 97 on any PC with Windows 98 as the OS, the formulas calculate correctly. When the worksheet is opened in Excel 2002 or Excel 2003 on a PC with Windows XP, the formulas produce #VALUE errors. I have installed the latest upgrade for Excel 2002, and looked into any add-ins that are on the Excel 97 machines, but the formulas are still not calculating correctly. Because the formulas work correctly in Excel 97, I am trying to avoid revising the formulas themselves. Any suggestions would be very helpful.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by mikex In reply to Opening Excel 97 workshee ...

Check out Trasition functions of the excel 2002 in the TOOLS/Options menu and in the "save excel files as" set up Excel 97-2000&5.0/win95 format this will avoid any future problems between the applications

Collapse -

by pfoley In reply to

Poster rated this answer.

Collapse -

by pfoley In reply to Opening Excel 97 workshee ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums