File opening as Read Only

[jaihawk8]

We have our files all saved to OneDrive. I have 5 users that access the files there. 4 of them work just fine, but one of them, when he opens the Excel files, it always says "READ-ONLY. We opened this workbook read-only from the server". This is causing issues, as we have several files with VBA scripts that open files and don't account for the "Edit Workbook" message.

Any ideas on what is going on here? I've gone through everything in his Trust Center settings and verified that they are the same as the other users. I'm at a loss.

 

[rlv01]

My guess is that it is not an Excel issue. To your user, it may be a read-only file, depending on the access level they have been granted to that OneDrive folder.

 

[jaihawk8]

My guess is that it is not an Excel issue. To your user, it may be a read-only file, depending on the access level they have been granted to that OneDrive folder.

I don't believe that is the case. I'm the top user, and here are the 2 users in question. One opens normal, the other opens read-only.

 

[rlv01]

How do you know that the file as seen from your problem user's machine is not marked as read only? Have you set Excel aside and checked the file attributes as seen from that PC?

 

[jaihawk8]

How do you know that the file as seen from your problem user's machine is not marked as read only? Have you set Excel aside and checked the file attributes as seen from that PC?

I have used Teams with all users to watch them try to run the script and have then had them go into individual files to see what they see, as well as right mouse click on the files and check the properties.

 

[rlv01]

Check out this article.
Why can't I edit shared OneDrive even after being given ownership/editing permissions?

Can your 'problem' user edit if you:

1. Upload another workbook to the same OneDrive folder?
2. Make a copy of the 'problem' workbook and place it on the same folder?
3. Try another document type, say a Word doc and put it on the same folder?