Question Locked

2 people accessing 1 Excel 2000 Spreadsheet

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a Windows 2003 server R2 Sp1 and XP SP2 workstations with Office 2000. Occasionally 2 users are able to access the same excel 2000 spreadsheet at the same time without receiving a file open notice until the second user tries to save the file. Then they receive a message stating that the file is in use and that they can do a save as. Usually if a user tries to access a file that is already in use, they receive a file in use popup and they are given the choice to open read only, notify or close. This issue does not happen all the time and is not specific to one particular file. And the file was never setup for sharing. I've checked my security and permissions for the shares and I don't see a solution. I've suspected file corruption and copied the data into a new file and replaced the old file thinking that would solve the problem and no luck. Is there something I'm missing?

3 replies

by travis.merrick

There are about 30 different ways to do this and I say use what works now.
To keep things simple in a simple in a small office environment, just open the document and then hit file- save as- and add your initials to the end of the file name before the extension. If its a sacred cow, just add NDM [Do Not Modify] or Master to the end of the file name. I know this is a band-aid, but
it works and you can see who modified what.
I hope this helps.
---------------------
"You can have it Good, Cheep or Tuesday, pick Two."

by retro77

Is the Office 2000 patches all the way to current on all machines? I would look into that. Sounds like a buggy Office.

This discussion is closed to new replies.