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?
51 Answer
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.
In excel it looks like this:
To have success with read only on sharepoint, you have to checkout the file (I'm too lazy to find the stack exchange reference).
