Shared Workbook READ ONLY access

[EFJ]

Currently have an excel workbook in a shared network drive in which multiple
employee has access in retrieving and make changes. There are a few
employees when they open the workbook it is a "Read Only" file. Tried
everything from looking at properties to make sure read only is not checked.
Try saving as a different name will not accept.

 

[Dave Peterson]

If the users only have read access to that folder (where your workbook file
resides), then excel won't bother asking. It'll just open the file in readonly
mode.

If you think that they have read/write/delete access, have them create a new
text file in that folder.

If it fails (and it's not supposed to), yell at your IT folks.

 

[EFJ]

Would having the workbook have protected cells and shared cause the
"Read-Only" access.
Could it be possible?

 

[Dave Peterson]

Locking cells on certain worksheets and then protecting the worksheet wouldn't
make the file readonly.

I don't use Shared workbooks at all, but this shouldn't have this affect
either. If it did, then sharing the workbook would be useless.

Did you ask one of the users having trouble to try to save a text file to that
folder?