×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel 97 “Document not saved”

Excel 97 “Document not saved”

Excel 97 “Document not saved”

(OP)

Have a user running Excel 97 SR2 on a Win95 box. Occasionally (maybe once a week) after simply entering data into the spreadsheet the user is not able to save. As soon as the user tries to save, an Excel error pops up “Document Not Saved”. It doesn’t matter which drive letter (this is on a network), local or network or whether you try clicking on File, Save As…, and giving it a new name. It will not let you save.

I found Q121942 in Microsoft’s KB which references the symptoms but the cause doesn’t seem to match. The article talks about embedded objects causing the problem but the cases we’ve seen occur after simple edits of data in the spreadsheet.

Any suggestions as to possible solutions would be appreciated.

Thanks!
Bob

RE: Excel 97 “Document not saved”

Bob, I've had this in the past, often with large documents, when memory is low, or when I've previously had a crash while editting. If File SaveAs doesn't work, try creating a new workbook, and using copy and paste to rebuild a new version of the file, this usually seems to get around whatever is locking up the old file.

RE: Excel 97 “Document not saved”

(OP)
Thanks for the input. That is in fact what we've been doing as a work around. Copying and pasting to an entirely new spreadsheet. Unfortunately not all of the formating copies over and user frustration is growing.
Bob

RE: Excel 97 “Document not saved”

For ANY file corruption and specifically for this problem, don't copy and paste. Instead, select all the sheets (Right-click on a sheet tab and click on "select all sheets.") Then right-click a sheet tab again, select Move or Copy, put a checkmark in "make a copy" and then hit the dropdown and select "new book." Save the new book to a different name. All formatting is kept. Some problems may occur with files that link to external files. Delete your old file and rename your new one.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close