When I edit a document it opens as Read Only (SPS 2003)
Hi: Does anybody knows why if one user is administrator of a site and edits a Word or Excel document, it opens as Read Only? He is opening the document with the 'Edit with Microsoft Office...' but he cannot save the document, and it isnecessary to deleteand upload it again, and he has to do it every time he wants to modify it. Regards.
January 30th, 2007 8:51pm
Sounds like you have it set to force check out.
January 31st, 2007 6:24am
CanI remove the force check out? Regards.
January 31st, 2007 11:15pm
You can. Go into the settings of the list or library and under Version Settings scroll down to the bottom of the page and uncheck Require Check Out from Yes and make it No.
January 31st, 2007 11:23pm
But how can I do this if I'm using Sharepoint 2003. I can only see that option in 2007.
February 1st, 2007 1:40am
I hate to jump on the old rant about " What version are you using" in the beginning of my explaination but that would have helpful here. Go into your document libary settings and click no for Requrie Content Approval. Hope this helps
February 1st, 2007 1:51am
Sorry about that, I know we could avoid all this. I'm sorry to tell that in the document library settings the Require Content Approval is set to No, and I still have the problem.
February 1st, 2007 2:53am
No problem.. it just helps as alot has changed between versions and where to adjust things. Does this happen with other document libraries? Other users?
February 1st, 2007 4:58am
We recentlyhad a similar situation with two users at my company. All Word, Excel, and PowerPoint documents suddenly started opening in read only mode. We also found the "Explorer View" in the document libraries did not work and could not use Windows Explorer to view WSSsite. Both users were running Windows 2000 with Internet Explorer 6 (IE 6)in SPS 2003 environment. We found both users also had a non-Microsoft program removed from their desktops that may have removed or modified some dlls shared by IE. The solution that worked for us was to reinstall IE 6 on each desktop (not a repair but reinstall). Hope this helps.
February 1st, 2007 7:02pm
Yes it happens with other document libraries that are in other sites, and also happens to other users. And it suddenly started to happen, because some time ago they could edit the documents without problems. I'vealso notice that the problem is not with all the documents in the document library.
February 1st, 2007 8:52pm
We are having the same problem as well. This morning, a user called to tell me the Excel file he had checked out and opened with "Edit with MS Excel" came up Read-Only. He left the file open while we were on the phone and about 5 minutes into the conversation, he noticed that it was no longer read-only. He made a small edit, saved and checked the file back in. We waited a few minutes, then tried again--again, Read-Only. Then I checked it out and was able to open it in edit mode. After checking it back in, he could then open it in edit mode. A half hour later, he could not. He can open and edit other Excel files in the same folder. Our site is SPS3, hosted by a third party. Another user experiencing the same problem had a company tech person reimage her computer and is still unable to open an Excel file in edit mode. (Reimaging included new IE, new Excel and new local profile on her machine.)
February 7th, 2007 10:10pm
Hi: I've done a lot of things and I can't find the answer. Is there a solution for this? Tks.
February 13th, 2007 2:01am
We had asked our ASP who hosts our SPS3 site to enable Integrated Authentication so we could automate a job having to do with moving data out of the SharePoint database into another one. This seems to have caused the read-only problem. They are now running both Basic and Integrated Authentication and the problem seems to have gone away.
February 14th, 2007 9:18pm
I have the same problem with Excel 2007. I am running a laptop with XP and Office 2003 SP2 and the "Edit in Microsoft Excel" link on the Sharepoint site (WSS) opens the the spreadsheet in Excel ready for editing. When you press 'save', excel pushes the document back up to the server. Everything works as advertised. If I attempt the same using a laptop running Vista and Excel 2007 the "Edit in Microsoft Excel" link renders the spreadsheet as [Read Only] in excel. If you attempt to save it, the save fails because the document was opened 'read-only'. Users have to save the document to their desktop and then upload it to the server later. The reason our organization keeps the documents WSS is to ensure we don't wat to risk opening an old or outdated copy of a document. Obviously the extra step introduces the very risk we set out to mitigate. Iuninstalled 2007, re-installed 2003 and the problem went away. The difference between the two is the WSS support tools. Unfortunately 2003 WSS support tools do not support the datasheet view (at least that I have found). So neither version really works as advertised.
April 5th, 2007 11:50pm
This looks promising - http://support.microsoft.com/kb/870853 In my case users who are not local admins have trouble checking in Excel spread sheets and they need the version control. I'm mostlikely going to try the registry hack suggested in this document.
December 14th, 2007 10:00pm
The Link above states clearly that this will not work for SharePoint. I am experiencing this error with several of the Libraries in a SharePoint environment, but not all of them. We are currently a mixed environment with Office 2003 & 2007 on MOSS 2007 as an upgrade from WSS 3.0.Has anyone found a solution for this?
September 17th, 2009 11:52pm
I am having the same problem and I have not found a solution yet. Here's my post which includes my setup/environment. http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/82979ab3-4c6e-4f8f-8671-cbdb796130e6/C# Developer
December 3rd, 2009 10:22pm
The Link above states clearly that this will not work for SharePoint. I am experiencing this error with several of the Libraries in a SharePoint environment, but not all of them. We are currently a mixed environment with Office 2003 & 2007 on MOSS 2007 as an upgrade from WSS 3.0.Has anyone found a solution for this? Mixed enviornment of office 2003 and 2007 on a machine may be the culprit for the issue. Also last time when i had the issue for a user, the solution was acheived by the below steps.1. Open IE - Tools - internet options - Advanced Tab - Uncheck the 'Enable the integrated windows authentication'. 2. At Security Tab- Custom level - User Authentication - Select the option - 'prompt for username and password'. 3. Clear the current IE cache - At General Tab - Delete History - Delete Files -4. At Drive:\Program Files\Microsoft Office\Office 12 , rename OWSSUPP.dll and run the microsoft office diagonostics or detect and repair after opening an office application.5.Try opening the file with the 'Edit in microsoft ...' option available.Try it out.Also check this link: URLScan details :http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/8f545459-aa90-4a28-ad85-420f09ef765e Regards, Aj (http://www.ajittgeorge.blogspot.com) MCTS
December 4th, 2009 3:44pm
Hi Pls. follow these steps to resolve your case. Go To Start > Run > Type webfldrs.msi Click on Select Reinstall Mode button (not Reinstall button)Select all options Click on OK Now click on the Reinstall buttonClick on OK Click on Yes to restart the machine or manually restart the machine. Regards Balu
December 10th, 2009 10:34am
Hi Pls. follow these steps to resolve your case. Go To Start > Run > Type webfldrs.msi Click on Select Reinstall Mode button (not Reinstall button)Select all options Click on OK Now click on the Reinstall buttonClick on OK Click on Yes to restart the machine or manually restart the machine. Regards Balu After days and hours of searching. And trying all the solutions, this is the only thing that worked. Thank you SOOOO much!!
December 11th, 2009 12:31am
HI Ajith, When i tried the above steps, It works for the first time and then the issue araises.. Is there any permanent solution for this issue.P N Bharath
April 28th, 2010 2:45pm
This is not really a corporate solution for a corporate problem.... We run WSS 2.0 and Office 2007 in an XP environment, up until the last month, users have been able to edit documents and save them back to the Document Library. When opening the document or spreadsheet, users would get a notification below the ribbon allowing them to switch to edit mode. This has now disappeared making all documents read-only, even if checked out. Version history is disabled in the Document Library settings, but is still applied. When ever I open the document, I now get a warning that there is a newer item available. I guess I'll keep looking.
May 25th, 2010 12:30pm
I had the same problem, however it was caused by having the default web browser set to a different product. Restore IE as the default web browser and happy days again!
October 20th, 2010 9:53am