The XLSM file is stored in OneDrive. If I open the file for editing, all is good, everything works.
If however I mark it read-only in the Properties tab -or- open it with Excel 2016 on Windows 10 using the /R switch, Excel gives me a line with yellow background telling me --
< bang > READ-ONLY This workbook is locked for editing by another user. < button labelled "Save As" >
I can prove to myself that it isn't locked by another user by copying the file using Explorer then opening it. Open it with no read-only flag set in Properties, no msg (about locked by another user). If I then change that flag and open it, Excel gives me the error message. Toggling this setting will consistently turn this error message ON or OFF.
Similarly, opening Excel using the /R switch and the filename (with read-only property unticked) reports the same message.
When I check the status of OneDrive it reports "OneDrive is to date".
Same also happens if I use right-click to create a new XLSX workbook in Explorer (obviously, no content & no chance yet for anyone else to open it!). The moment I change the property to read-only Excel gets upset that it is read-only.
Why is Excel telling me it's read-only, or I only have read-only access? I know ... I made that "true" myself.
I know I can discard the line by clicking the X at the right-hand end, but I would like Excel to stop producing this message. Once users start accessing the file (probably thru Sharepoint 365), I don't want them to get the same message as it might well confuse them! It's only recently started to happen. Does anyone have any ideas how this might be achieved.
If however I mark it read-only in the Properties tab -or- open it with Excel 2016 on Windows 10 using the /R switch, Excel gives me a line with yellow background telling me --
< bang > READ-ONLY This workbook is locked for editing by another user. < button labelled "Save As" >
I can prove to myself that it isn't locked by another user by copying the file using Explorer then opening it. Open it with no read-only flag set in Properties, no msg (about locked by another user). If I then change that flag and open it, Excel gives me the error message. Toggling this setting will consistently turn this error message ON or OFF.
Similarly, opening Excel using the /R switch and the filename (with read-only property unticked) reports the same message.
When I check the status of OneDrive it reports "OneDrive is to date".
Same also happens if I use right-click to create a new XLSX workbook in Explorer (obviously, no content & no chance yet for anyone else to open it!). The moment I change the property to read-only Excel gets upset that it is read-only.
Why is Excel telling me it's read-only, or I only have read-only access? I know ... I made that "true" myself.
I know I can discard the line by clicking the X at the right-hand end, but I would like Excel to stop producing this message. Once users start accessing the file (probably thru Sharepoint 365), I don't want them to get the same message as it might well confuse them! It's only recently started to happen. Does anyone have any ideas how this might be achieved.
Last edited:
