Excel 97 - Document Not Saved error when saving

We keep having an Excel 97 error occurring.

When a user has finished updating an Excel file & they try to save the file an error comes up on their screen ?Document Not Saved?.

Some of the XLS files have VBA & Micros in them but some don?t.

Nearly all of the files that are having this problem are on a shared drive.

We think the problem is down to people clicking on ?Notify? when someone is editing the file. Then the person who clicked on Notify saves the file and then the original person who opened the file tries to save it and they get the error. We have not been able to find out whether this is the problem yet?

I want to know if this is the answer and if so how to stop the error or and we disable the Notify button when a second person accesses the file.

Or is there another reason for this error.
FowlesSAsked:
Who is Participating?
 
q2eddieConnect With a Mentor Commented:
Hi, FowlesS.

#Links
1. "File Management"
http://kitap.ankara.edu.tr/0789711656/htm/ch06.htm

Look for the section titled "Shared Workbooks: Setting Up".

Bye. -e2
0
 
travalCommented:
One more:

Q216833 XL97: Cannot Save Workbook After Losing Network Connection
http://support.microsoft.com/support/kb/articles/q216/8/33.asp
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
amp072397Commented:
FowlesS:

Please provide feedback.

amp
Community Support Moderator
Experts Exchange
0
 
costelloCommented:
If no objections are made in the next 5 days, I will force accept the contribution by q2eddie.

costello
Community Support Moderator @ Experts-Exchange

P.S. This post is made as part of the general effort to clean up this topic area, meaning, looping through all the open questions with no activity since 21 days.
0
 
Computer101Commented:
Comment from q2eddie accepted as answer.

Thank you
Computer101
Community Support Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.