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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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
All Courses

From novice to tech pro — start learning today.