0

I have a file that I'd like others (potentially a dozen+) to have access to at all times, but that I can also edit even if others have it open. If I make it so it requests the user open it as Read Only, and assuming they do so, would that still allow me to edit the file if they have it open as Read Only?

TexMurphy4
  • 1
  • 1

1 Answers1

0

You maybe be able to use one of the other Protect Workbook options, but I do a different route: I go out to the directory and right-click-> properties and (un)check the read-only attribute.

enter image description here

In excel it looks like this:

enter image description here To have success with read only on sharepoint, you have to checkout the file (I'm too lazy to find the stack exchange reference).

gns100
  • 1,261