Excel 97 and Excel 2002

[Distressed in Maryland]

We work on a network, that has a dedicated server and
about nine workstations. One workstation is running
Microsoft Office XP (2002) and the others are using parts
of Office 97 (i.e. one has Excel 97 and Word 97 only, one
has Excel 98 and then Word 97, the others have Office 97
but not Access). The problem is one workstation will
access an Excel file created by the workstations using
Office XP. After changes are made to the file, the
workstation tries to save the excel document and it
doesn't save it, it gives an error and saves the document
as a temporary file. Is this due to a compatibility
issue? Is there a way that the workstation running XP
can save their Excel and Work documents so that everyone
else can access them. We all use the same files and it
seems whenever the XP user opens a document, no one else
can then access the document without getting errors.
Thanks for any suggestions, hints or ideas you can
provide.

 

[Gilles Desjardins]

You mention Excel 98 ,if that is not an error you are talking about an Apple
computer. Only Office 98 is compatible with Macs. You mention that everyone
share an Excel file. Perhaps here lies the problem? just a thought.

Gilles Desjardins

 

[immanuel]

What is the exact error message that you receive?

Check Tools / Options on your XL2002. On one of the tabs, you have the
option to choose the default format in which to save. Change it to 97/2000
& 2002 format.

/i.