Read Only Error In Excel 2010
Contents |
Xochitlahtol Microsoft Office 2010 - issue with opening files as "Read-Only" By jrogel November 21, 2012 Excell 2010 Office 2010 PC Protected View Read-Only problem This happened to me the other day when trying to open an older(-ish) how to remove read only from excel 2013 Excel file created with Office 2003 in the new 2010 version of the software: I word 2010 remove read only double clicked on the file and a message appeared telling me that the file will be opened in read-only mode and that excel opens in read only mode 2010 whenever it becomes free then I will be able to edit it. The strange thing is that no one else had the file opened.If you have the same issue with your files, read on. There seems word documents opening in read only mode 2013 to be a new feature in the 2010 edition of MS Office called Protected View created to "enhance protection against mail attachments, files originated from the internet and located in unsafe locations". This sounds great, but the problem is that Protected View will remove support for legacy document formats, and causes these documents to be opened in read-only mode. A solution posted my Microsoft is: Run the Office 2010 application with the problem.
Word Documents Opening In Read Only Mode 2010
Notice that this procedure has to be done individually with each of the applications in MS Office suite (great!). Click on the Office button on the upper left-hand corner and select "Options" In the "Options" dialogue box, select "Trust Center" (on the left) Click on "Trust Center Settings" (on the right) Select "Protected View" Disable any of all the protected view options by unticking the check boxes. Click OK when done. Another alternative is to re-save your legacy document. In order to do that do the following: Open the problematic legacy document Click File and select Save As In the dialogue box, on the lower left-hand corner there is a drop-down menu called "Tools", select "General Options" Make sure that the "Read-Only recommended" check box is unticked. Save the file and hope for the best… I hope this is useful to you. Rate this:Share this:Click to share on Twitter (Opens in new window)Share on Facebook (Opens in new window)Click to share on Google+ (Opens in new window)Click to share on Tumblr (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to email (Opens in new window)Click to print (Opens in new window)Click to share on Pinterest (Opens in new window)Click to share on Reddit (Opens in new window)Like this:Like Loading... Related Posted in Computers, Ge
be down. Please try the request again. Your cache administrator is webmaster. Generated Wed, 26 Oct 2016 03:03:35 GMT by s_wx1157 (squid/3.5.20)
for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us SharePoint Questions Tags http://sharepoint.stackexchange.com/questions/58215/excel-links-open-files-as-read-only-mode-how-to-change-this-to-edit-mode Users Badges Unanswered Ask Question _ SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Excel links open files as read-only mode. How to change this to edit mode? up vote 6 down vote favorite Does anyone have any idea why using the link on excel opens the file as read-only 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 excel excel-services share|improve this question asked Jan 28 '13 at 22:12 MicroSumol 2832823 add a comment| 5 Answers 5 active oldest votes up vote 2 down vote 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 remove read only "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: share|improve this answer answered Jan 28 '13 at 22:35 Alex 59921841 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 a comment| up vote 2 down vote The setting you want is in Excel, not in SharePoint. Excel will,