There's an Excel file on the network that is frequently accessed (daily) by multiple users. They make quick changes to it, save it and then close it. I've just been told that something has started happening on a recurring basis. When the user has made changes to the file and clicks the close button (X in the top right corner of Excel) it asks them if they want to save the changes. They click Yes and everything seems fine. The problem is that sometimes the next time they go into the file the changes are missing. They say that it appears that if they choose to save it (File>>Save) before exiting the program this doesn't happen. We use Excel 97 SR2 on Win98SE and an NT 4.0 network. Any ideas anyone or is this just "user error"?

It is possible that the user has made changes to their default settings in Excel and it is trying to save the excel document in a different format than the other users. It is also possible that another user is accessing the file at the same time and one overwrites the other. File sharing can be tricky like that. www.coolgeeks.net

I don't suppose any of your users changed the default save setting to something else? Just a thought, Ken

I understand that only one person can actually read/write at one time. If, when the file is opened and someone else has the read/write they will get the message to view only or notify. When in read only they will get the message upon closing for the option to save to another file. It will not save to the original file when in read only. So, if they did actually save it, it is on their hard drive, likely by the same name. Perform a search (Find) for the file, copy and paste the entire worksheet to the shared file and choose overwrite if it is a large amount of data or simply re-enter to the original file.