Taking Control of Checked Out Documents in SharePoint

By:   |   Updated: 2010-02-23   |   Comments (3)   |   Related: > SharePoint Administration


Problem

Often times users leave SharePoint documents in a "Checked Out" status. This can happen for a variety of unintended reasons. As an administrator, I would like to be able to remedy these situations when they happen. Is there a way to do it without having to log in as the user?

Solution

Yes. As a user with "Full Control" of a SharePoint site, you can take control of "Checked Out" documents.

First let's understand some of the reasons why documents are in a Checked Out status.

  • The obvious:
    • A user might really be working on the document. Don't under-estimate this.
    • A user doesn't understand how SharePoint works. Offer frequent SharePoint trainings on various topics.
    • A user may have left the project, the department, or even the organization.
  • Not so obvious:
    • The document 'check out' feature can cause documents to be 'checked out' without the user realizing it. Here's how:
      After clicking the 'Browse" button to upload a document, the user finds a document and clicks "OK". They are then presented with a form to fill out various metadata fields about the document. Even before completing the form, the document has actually been uploaded to the system. (This is transparent to the user at this point.) If the document library has the document check out/in requirement set and the user, for whatever reason, doesn't complete the form and simply closes the web browser (perhaps they don't have enough information to complete all the fields), the document will remain in the system in a 'checked out' status. The user won't really know because the web browser has been closed.

For the obvious reasons, you will see that a document is checked out, and as a user with Full Control, you can 'check in' the document directly.

If it's the last ("not so obvious") reason, even a user with Full Control will not see the document at all in the document library. To remedy the situation, you must follow the procedure below:

In the document library, click "Settings", then "Document Library Settings".

create column

Click "Manage checked out files".

manage checked out files

(If you see any documents with checkboxes next to them here, you can be pretty sure there is an issue that needs attention.)

Check the checkbox next to the document you want to take control of. Then click "Take Ownership of Selection".

ownership of collection

In the library, you will now see the document, but it will still be in a "Checked Out" status. (Notice the little green box with the white arrow.) Click the document dropdown and then select "Check In". (You may need to complete any required metadata fields.)

check in

After completing the process, the document will be in a normally checked in status.

rob fisch

Notice that, in this case, now I am the last person listed as modifying the document.

Next Steps


sql server categories

sql server webinars

subscribe to mssqltips

sql server tutorials

sql server white papers

next tip



About the author
MSSQLTips author Rob Fisch Rob Fisch has worked with SQL Server since version 6.5 as a dba, developer, report writer and data warehouse designer.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips


Article Last Updated: 2010-02-23

Comments For This Article




Thursday, January 25, 2018 - 11:54:54 AM - CathyInCanada Back To Top (75038)

Interestingly enough, as the Admin, I navigated to that page and no documents were displayed. When I go to the document itself to Edit, the system returned a message that it was checked out by my team member. I sat with the staff to do a Check Out, then Check In, and then a proper close of the document and browser. Still the system thinks the file is checked out.

No idea how to resolve this except to wait a long time until the system seems to just release the check in status randomly. Very frustrating.


Tuesday, December 20, 2016 - 1:51:25 PM - Lauren Back To Top (45010)

 is there a way to do this in SP2013? 

 

 


Thursday, October 20, 2016 - 11:45:57 AM - Michelle Smith Back To Top (43603)

 

 Thank you very much for this post Rob! It helped me to solve the issue that I was researching in SharePoint!















get free sql tips
agree to terms