Excel unable to edit in Sharepoint

Question

Excel was creating in desktop excel and drag to Sharepoint, all set to editable by the owner or whoever has the link however when open in the Sharepoint is still show "view only".

How to I change it to editable? So my colleague all can edit.

Answer 1

@Elyn Goh ,

Does the issue occur on the excel online or the client?

Make sure that users have appropriate permissions for these files, such as "contribute" or "edit".

Please create a brand new library, upload these files to it, compare the results, and post it back.

More information for your reference:

https://learn.microsoft.com/en-us/sharepoint/troubleshoot/lists-and-libraries/files-open-as-read-only-and-cannot-check-in-or-out

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.