Maybe you can ask your IT staff to create a share that only you have write
access to. The others can have readonly access.

Then excel will work with windows and respect those settings. You'll be able to
open it without a password and the others will be able to open it in readonly
mode.

No passwords would be required.

If you get your IT staff to do this, you may want to include a trusted co-worker
who can update the file when you're not in the office.



artemis1027 wrote:

Is there a way to do it in which it doesn't ask for a password every time?

"Bob I" wrote:

Make it readonly. File, Save As, Tools, general Options ,Password to modify.

artemis1027 wrote:
I have a workbook in which I keep track of Criminal Records that have been
run. I updated this daily and others check it daily. Is there a way that I
can be in it editing while they are looking? I also don't want them to be
able to make any changes to the workbook, just me.



--

Dave Peterson