The dreaded "Document Not Saved"

b1n0ry

New Member
Joined
Mar 1, 2007
Messages
7
We recently upgraded a Novell 4.11 file server to Windows 2003. Now, at random, Windows NT 4, 95, and 98 clients that access large Excel spreadsheets get the dreaded "Document Not Saved" when attempting to save back.

I've read the Microsoft KB articles and I assure you that the problem is definately not a lack of disk capacity or a connectivity problem. Other applications stay running fine (at the same time), and most computers are connected via a port on a 100Mb VoIP phone. If connectivity were the issue, the phone would lose a connection.

I have attempted upgrading from Office 97 to Office 2000 with all service packs. I have attempted deleting all temporary files on both the local PC and the network server. I have attempted deleting and recreating new files. I have attempted copying the file to one system and back to the original location. When this problem happens, a "Save As" generally doesn't work afterwards - and due to heavy VBA macros and formatting, copying the data to a new spreadsheet is not a viable solution.

In addition, I'd be asking the guys to save to new locations and new files and new data literally 20-30 times a day. That's not an option.

What I need is for it to just "work". I need the guys to be able to hit "save" and have the document saved from where they opened it without jumping through hoops.

Sorry if I sound frustrated, I've been fighting this issue for about 6 months.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Thanks for the reply. I have reviewed each of those articles at some point in this troubleshooting process. None of these systems had these problems prior to upgrading our primary file server.

If the local computer was momentarily losing a connection during the save, the problem would have shown up before the upgrade as well... and multiple PCs? If the server were losing a connection, then all users would be effected, and they aren't. Windows XP computers running Excel 2003 have no problems that I've found at all.

The drives do not have quotas enabled and we have roughly 10x the capacity of the previous server, so disk capacity isn't an issue.

All users are "local administrators" of their own machines, so the problem can't be a security-related issue.

Asking them to save "differently" isn't an option. There are multiple workbooks that they have this problem with and multiple PCs. These workbooks are saved roughly 30 times per day each (when working properly). In relation to man-hours, having them go through hoops (i.e. save to the local computer then copy down to the network share and overwrite the existing file, etc.) would literally consume hours each day.
 
Upvote 0

Forum statistics

Threads
1,214,606
Messages
6,120,492
Members
448,967
Latest member
visheshkotha

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top