General discussion

Locked

excel: document not saved

By serceg ·
Hello,

There are about 30 users who share a workbook and when they attempt to save some changes they've made they receive the following error.

'Your changes could not be saved to 'xxxx.xls', but were saved to a temporary document named 'xxxx.xls'. Close the exisiting document, then save it under a new name.'

When they try to save under a new name, either clicking on save or save as, it bring up: 'Document not Saved.' The only way it would save is if I selected save as workspace.

I've read some cryptic answers about Anti-Virus being the cause or loss of network connection....any other possibilities?

They are mixture of users using either NT or WinXP with either Office
2000 or 97.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by fungus-among-us In reply to excel: document not saved

"There are about 30 users who share a workbook..."

You have 30 users sharing a workbook.... but are you saying that you have 30 users who access the same file or is the XLS actually setup as "Shared".

If the file is actually shared, make sure the checkbox for "allows changes by more than one user at the same time. This also allows workbook merging" is checked.

Get back, and let us know.

Collapse -

by serceg In reply to

Thx guys for getting back to to me. 30 users do access the workbook and it is set up as shared and checked off so that more than one user at the same time can make changes. It seems to happen sporadically and I'm new to this company but the network seems flaky and loses connectivity...I'm wondering if that's a contributing factor? Once the temp file error happens, if you go in and try to select save or save as...that's when you get the document not saved error...it won't even allow you to save it locally or elsewhere.

Collapse -

by robo_dev In reply to excel: document not saved

You must use the built-in Excel function called 'Share Workbook' or this will never, ever work.

When you open a file in excel, it creates a copy of the file and works on that copy of the file. It marks the original file as read only. If you close with out saving, it deletes the temporary file. If you do a save, it deletes the original file and renames the temporary file. A user cannot save to a read-only file, therefore more that one concurrent user will get errors. Also, if a user somehow were to violate the file integrity and update the file while another user had it open, it would likely end up being hopelessly corrupted.

http://support.microsoft.com/default.aspx?scid=kb;en-us;271513

Collapse -

by serceg In reply to

Thx guys for getting back to to me. 30 users do access the workbook and it is set up as shared and checked off so that more than one user at the same time can make changes. It seems to happen sporadically and I'm new to this company but the network seems flaky and loses connectivity...I'm wondering if that's a contributing factor? Once the temp file error happens, if you go in and try to select save or save as...that's when you get the document not saved error...it won't even allow you to save it locally or elsewhere.

Collapse -

by serceg In reply to excel: document not saved

Sorry...I looked further into the link provided to me and answered my question about the network connectivety being the issue. thx for your help.

Collapse -

by serceg In reply to excel: document not saved

Point value changed by question poster.

Collapse -

by serceg In reply to excel: document not saved

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums