Does anyone have any idea why using the link on excel opens the file as read-only mode? How can I change the behavior to open as Edit mode?
I checked almost all of the Document Library settings, but so far no luck.
Thank you for reading
Assuming you are using SharePoint 2010, go to your document library's Settings, then click Advanced Settings. Find the option for "Default open behavior for browser-enabled documents", and select "Open in the client application". Now, when a user clicks on the document name to open it, they will be able to see that they can edit it and select the "edit" option from the prompt (assuming you are using IE). Here is what that should look like: