Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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?

enter image description here

I checked almost all of the Document Library settings, but so far no luck.

Thank you for reading

share|improve this question
add comment

1 Answer

Try this:

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:

enter image description here

share|improve this answer
Hello Alex, The "Open in the client application" was already the current setting. The problem I am having is that when the user clicks the link-->opens excel file-->make one change-->Save. It says that the file is read only. But if the user goes "Edit in Microsoft Excel" everything just works as expected. –  MicroSumol Jan 28 '13 at 23:06
If you use the method that I showed above and select "edit" after clicking on the document link in the Library, I don't see how it could say the file is read only if you open it in edit mode. No need to use the dropdown and select "Edit in Microsoft Excel". –  Alex Jan 28 '13 at 23:10
But that windows is not showing up on Excel 2010. I tried 2 different machines. –  MicroSumol Jan 29 '13 at 18:27
It's not part of Excel. I am also on Excel 2010. I think you need to configure your Internet Explorer security settings to prompt for this. –  Alex Jan 29 '13 at 18:39
add comment

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.