Solved

Excel 97 - Document Not Saved error when saving

Posted on 2001-06-06
6
4,296 Views
Last Modified: 2008-03-17
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.
0
Comment
Question by:FowlesS
6 Comments
 
LVL 7

Accepted Solution

by:
q2eddie earned 300 total points
ID: 6161855
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
 
LVL 13

Expert Comment

by:cri
ID: 6163441
0
 
LVL 21

Expert Comment

by:traval
ID: 6164956
One more:

Q216833 XL97: Cannot Save Workbook After Losing Network Connection
http://support.microsoft.com/support/kb/articles/q216/8/33.asp
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Expert Comment

by:amp072397
ID: 6242745
FowlesS:

Please provide feedback.

amp
Community Support Moderator
Experts Exchange
0
 

Expert Comment

by:costello
ID: 6414785
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
 
LVL 1

Expert Comment

by:Computer101
ID: 6507162
Comment from q2eddie accepted as answer.

Thank you
Computer101
Community Support Moderator
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some time ago I was asked to create a VBA function that would calculate a check digit for an input number, using the following procedure: First, sum up all the individual digits in the number If that sum value has more than one digit, then sum up …
Introduction It seems that at least a couple of times per month, I answer a question that requires automating Outlook from another Microsoft Office application, usually (although not always) to send one or more email messages.  For example: …
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now