Click TOOLS on the menu and select SHARE WORKBOOK and on the EDITING tab of
the dialog box, check the ALLOW CHANGES BY MORE THAN ONE USER AT THE SAME
TIME to on.

However, shared workbooks come with their own set of quirks, problems and
issues. You might consider using Access in a multi-user environment,
especially with the number of users you mentioned as being as many as 40.

Good luck...
--
Kevin Backmann


"Mac1" wrote:

My daily roster worksheet is on a shared drive and accessed by up to 40
people on a 24 hour basis.
First one to open it automatically locks it and others ,including myself,
have 'read only' access. I need to edit this roster several times a day. Can
I configure this worksheet to allow myself only to have 'locked for editing'
permission and all other users 'read only' access.

Thanks

Mac