.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Read-Only mode is not working for office document-Bug

Posted By:      Posted Date: September 09, 2010    Points: 0   Category :SharePoint
I have a excel file in the document library. In client PC I have office 2007. Suppose two users click on that excel file. A small window pops up to select mode(edit or read-only). User1 selects edit and user 2 selects read-only. user1 made some modificatin on the document. After that save and close the file. Now user2 click on save button he also can save the file. That means modification made by user1 is overridden by user2. So it should not happen. It's a Bug. If the user opening the document in Read-Only mode then save button should be in disable mode. If any one has any workaround. Please let me know.

View Complete Post

More Related Resource Links

Link to my Office Document opening in Read-Only mode


I have an excel document in my Pages library which has document check-out disabled and I have contribute permissions on the library.

When I go to the Pages library and click on the name of the excel document, it rightly opens and allows me to edit it and then save it back.

BUT, when I put a link to that document on an aspx page and click on it, it opens in Read-Only mode.

I get the same behavior for Word documents.

How do I get the link on the aspx page to be editable? 

Office 2007 Documents Open in Read-Only when Opening them from a WSS 2.0 Document Library

Hi, When any of our Windows 7 Pro computers that run Office 2007 Pro attempt to open a Word document that resides in a WSS 2.0 document library by using the drop down menu and selecting "Edit with MS Word", the documents open in read-only.  Our work-around is to save the document locally, modify it, and then save it back to the document library. We have some Windows XP and Vista systems that run Office 2007 and they are fine and can simply edit the document and save it.  We also have a handful of pc's that run Office 2003 and they are not having any issues either. Things I've tried: Office 2007 Repair - no luck Office Reinstall - no luck Some registry mod HKCU\Software\Microsoft\Office\12\Internet\OpenDocumentReadWrite=1 (noted on a MSKB article) - no luck and after re-reading the article it clearly states that this will not address content hosted on WSS or SPS sites Clearing IE temp files, resttting IE to defaults - no luck Once again, this only seems to happen to Win7Pro pc's that run Office 2007.  Honestly, I can't tell if IE8 has anything to do with this. Any thoughts or help would be extrememly appreciated. Thanks, Mike

Document is read-only in SharePoint, but user sees "check out" option in Office 2007 / Word / Excel

I am finding that when there is a document library in SharePoint with checkin/checkout required, if a user with read-only ("Visitor") permissions opens a document from that library, the document will open as read-only in Word, Excel, etc., but the user will see the "Server Document" bar with the message "To modify this document, you must check it out" and the "check out" button.  When the user tries to check the document out, they are asked to authenticate, and then receive the error "Cannot perform this operation.  The file has been deleted or someone else has it checked out."    How is it possible to prevent a user with read-only rights in SharePoint from seeing the "Check out" option in Word or Excel?

Working with SharePoint document libraries

Document libraries are collections of files that you can share with team members on a Web based on Microsoft Windows SharePoint Services. For example, you can create a library of common documents for a project, and team members can use their Web browsers to find the files, read them, and make comments. Users with Microsoft Office 2003 can check out and edit the files as if they resided on a local or network drive.

By default, your team Web site comes with a built-in document library named Shared Documents, which is listed on the Quick Launch bar as well as on the Documents and Lists page.

Office Development: Manage Metadata with Document Information Panels


Here the author uses Document Information Panels in the Microsoft 2007 Office system to manipulate metadata from Office docs for better discovery and management.

Ashish Ghoda

MSDN Magazine April 2008

Advanced Basics: Setting Word Document Properties the Office 2007 Way


The last time I wrote this column (March 2006), I shared an application that allows you to update all the Microsoft® Word documents in a folder and its subfolders. Each time the application finds a document in the specified path, it updates the document properties to match those you specified in the application.

Ken Getz

MSDN Magazine June 2006

In sharepoint excel working fine in office 2007 but not in office 2010


Hi All,

we receive error  while trying to create excel sheet using the template we have uploaded on the SharePoint 2007.


This occurs on a machine that has Office 2010 installed. Earlier the machine had Office 2007 and everything was working fine.


Can you let me know why is problem is coming and how to resolve this.



Sanjeev Tiwari


Sharepoint 2007 Document Search and Highlight in Office 2007 and PDF


We will be implementing Document Search (DOC, DOCX, PDF, TIFF, PPT, PPTX, XLS, XLSX) for one of our customers. We were evaluating a few MOSS 2007 based solutions, and happened to visit your site.  What we intend to achieve are the following functionalities:


a.       User should be able to search through 1000s of documents which are in a Sharepoint Document Library

b.      The documents could be in English, International Languages.

c.       Each document is 70-100 pages, and therefore it is important that the Search Results show the relevant pages on which the Search Text appears (Get Highlighted) within each document . Clicking on the link will take the user to the right page.

d.      The additional requirement is Synonym search. So, I can search for

Office Sharepoint Server Search not working but Windows Server Search is.

I am having an annoying Issue with the Sharepoint 2007 Enterprise search functionality. I cannot get the Search Centre to work, the out of the box webparts crash the page except the Searchbox when the others are closed. The event viewer shows up numerous Errors (Office Sharepoint Server - EventID 7080) returns with and the same when trying to add a search related web part (e.g. core.results, federated etc). EventID 6398 - Timer is a regular as is 7080. Details below.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified).

Remote connections are connected, I am not 100% on the Instance name, (how would I go about checking this?)

Also I cannot access the link to SharedServices1 - Open Shared Services Admin site (not clickable), guess it's permissions but I seem to have full site permissions, I think I need SSP-Admin to make more edits to the Search, maybe this is related :s

Both Search Servers are runnig, I have tried everything I can think of to fix this and allow the Search Centre to work.

I am running Sharepoint 2007 on SQL Server 2008.

Check-out issue when opening a document from a document library when a read-only copy is open

We have an issue when a user has a read-only copy of a document from SharePoint open and then tries to check-out and edit another copy of the document (i.e. from the document library) the checked out copy is not connected to the web server. For the user it will look the same they will make edits, save and then close, but when they do so the document is not updated in SharePoint - it may be saved locally in their SP drafts, but the user will think that they have lost their version. We then get the checked out to another user error and you have to discard changes to get the document working again. Steps to reproduce this issue: * click on the name of a office doc on a Document Library * Make sure "Read Only" is selected and click "ok" * Minimize open document * click on the same file on the Document Library * Make sure "check out and edit" is selected and the "Use my local drafts folder" checkbox is ticked. Select OK. * Edit document and press save. Changes are never saved back in SharePoint, they are only on the local draft. We are using MOSS with SP2. Clients are on Office 2003 and 2007 Is this normal behaviour? Is there anything that can be done to prevent this from happening?

Moved from WinXP to Win7 - don't see choice to open file in read only or edit mode


I just recently moved from Win XP Pro SP3 to Win 7 32-bit Pro. I am logging into domain X normally. Our Sharepoint 2007 server authenticates only on domain Y. So I start Internet Explorer with "run as different user" and provide my domain Y credentials. All fine. 

In win XP, after I did this, when I click on an Excel file on Sharepoint, I would get a dialog asking if I wanted to check out and edit or open as read only. 

In win7, I don't get that choice. The file simply opens, and I get a bar at the top which allows me to check out the file if I wanted to. 

How can I restore the functionality I used to have, with the dialog for checking out the file before opening it?

Working with In-Memory Open XML Documents (Office Talk Column)

Working with Open XML Documents without loading from a file or saving to a file is important when you build applications that work with Microsoft SharePoint Server 2010 or Microsoft ASP.NET Web applications.

SharePoint makes Office Document custom fields unreadable


We're using WSS 3.0SP2 with a Document Library that has document-level columns (fields) added. The columns (fields) are defined as single-line text; nothing fancy. In SharePoint we can set the field values no problem. When we pull the documents back out of SharePoint to the file systsem, and look at the Custom Fields, the values are unreadable gibberish. They look like graphics lines and boxes and the Type is set to Unknown.

Any ideas why this is happening and how to fix it?

Read Excel sheet by Sheet Name using office interop

Hi,I am using office interop to read Excel sheet.I want to read the contents of the sheet  using the name of the sheet.For example I want to read the contents of the sheet- "ABC" (if ABC exists).Thanks

Updating a non MS Office document

Hi, We are using SP2007 My understanding that the only way to update a non Office file (eg .txt) without using My Network Places in a SharePoint document library is to do the following: check out the document save the document locally  upload the document as a new version check in the document Is this correct? If so ... if a user has full control on a given document but only read only access to the library it sits in, doesn't it mean they will not be able to update the document (without using My Network Places) as they don't have access to the libraries Upload option? We are trying to avoid using the My Network places due to using thousands of site collections across our organisation ie trying to find a specific library is hard to do and is a poor user experience.   Regards, Simon 

Not always prompted for read-only or EDIT mode, when opening files with IE7, Sharepoint 3.0

Hello Everyone,   We use Sharepoint 3.0 and when I click on a document I get a pop up prompt that asks me whether I want to open the file in READ-ONLY or EDIT mode.   I use a machine with XP Pro that is running IE7.   A user called me today, also running IE7, and when he clicks to open a Sharepoint file he gets a different prompt - a simpler one that just offers OPEN or SAVE.   I don't care that his prompt looks different - the problem is that he is able to open the file, make edits, but then when he closes the file (using Excel) he isn't able to save his changes.   Excel only provides a save-as option for him.   This isn't a permission problem with his ID.   When I login to our Sharepoint 3.0 system as him, with his password (from my machine), I get the usual Read-Only / Edit prompt and when I open a file in EDIT mode I am able to save my changes with no problem.   Any thoughts on this?   Chris

Office document are not opened correctly! (XLSX gives error. XLS asks login)

I have SharePoint 2010 based farm and MS Office 2007. SharePoint have Enterprise feature enabled. In my test I'm opening documents in the front-end machine. Problem 1: When XLSX excel documents are tried to be opened, it try to open to the browser. Error is given: Your request can not be handled. Please wait few minutes and try again.(free translation from local language) Because of error I started Excel services, but nothing changed. Problem 2: When XLS excel documeents are opened, it opens to the Office Excel client, but it request login. After login xls document is opened correctly. Why I need to login? Problem 3: When DOC word documeents are opened, it opens to the Office Word client, but it request login. After login doc document is opened correctly. Why I need to login?Kenny_I
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend