When I edit a document it opens as Read Only

When I edit a document it opens as Read Only

• bpsmith

  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. I uninstalled 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.

  
  

• NoEgo

  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.

  
  

• JeffBrown

  We recently had 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 WSS site. 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.
  

• samame

  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

  
  
  

• Al33327

  Hi:

  I've done a lot of things and I can't find the answer.

  Is there a solution for this

  Tks.

  
  

• crazyabtdotnet

  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.
  

• deviprisoner

  Sounds like you have it set to force check out.
  
  

• NET PR

  Can I remove the force check out

  Regards.

  
  

• pravinarote

  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.

  
  

• soconne

  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.)

  
  

• Khenat.Ram

  But how can I do this if I'm using Sharepoint 2003.

  I can only see that option in 2007.

  
  

• luigidor

  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've also notice that the problem is not with all the documents in the document library.

  
  

• Malleswar

  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

  
  
  

• rivers

  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.

  
  
  
• When I edit a document it opens as Read Only