General discussion


Excel File locks for editing!!!!

We rebuild a couple of systems with windows 2000 professional and we also installed office 2000, they have SR 1a and service pack 3 for the OS and for office. When they open an excel sheet that is saved on the shared folder on a 2000 server. They get an error the the file is locked for editing by them, or by one other user. But the file is not being used. I've closed the app, open it as read-only then save as to their local drive and save it back to the share drive with different name, they areable to open it and close but when they try to open it again they get the same error. Need some help thanks.?????????

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel File locks for editing!!!!

by mfischer In reply to Excel File locks for edit ...

The permissions are set to read only. Senario 1.

1. Share permissions give everyone FULL CONTROL but NTFS permissions (they're different) give the group you're in read only access.

2. NTFS permission are full control but the SHARE permissions are read only for that group.

Windows 2k applies the most restrictive permission that is associated with a particular file or folder.

You must be in a group that has some administrative access in order to change the NTFS or Share permission.

Collapse -

Excel File locks for editing!!!!

by LEROSERO19 In reply to Excel File locks for edit ...

Related Discussions

Related Forums