Using Document Check Out with SharePoint

By:   |   Comments   |   Related: > SharePoint Document Management


Problem

I am just getting started with SharePoint and would like to start using the Document Check-Out feature. I can't tell when documents are checked out, nor to whom. I can't even tell if the feature is on. How does the feature work?

Solution

Check-Out is a critical feature for document collaboration. When multiple users are sharing and editing the same files, it is important to know when a particular document is in the process of being edited so versions do not get out of sync.

SharePoint comes with this feature, however it is not enforced by default and there is a customization to library views that must be made in order to make it visible.

Additionally, there is a squirrelly behavior when using the 'local drafts' feature. This is a widely posted 'watch-out'. I'll show how to avoid the problem in a bit.

The first task is the expose some built-in Check-Out fields. In your view (i.e. All Documents), click the View dropdown and select "Modify this View".

1 Modify this view

Expose the "Check In Comment" and "Checked Out To" fields.

2 show checkout fields

Now we'll turn on the Check-Out requirement. By default, Check-Out is not required...which means users can edit documents freely without checking them out. So during simultaneously editing, the last person that 'saves' the document overwrites a previous persons changes. (Note: Without Check-Out being required, the feature is optional and can still be used, but when not specifically used, there can be trouble.)

Click on the "Settings" menu of the library and choose "Document Library Settings".

3 Library Settings

Click "Versioning settings".

4 Version Settings

Change the "Require Check Out" section to "Yes".

5 Require Checkout

Now let's check out a document and see what happens.

Hold the mouse over the document name and click the dropdown menu. Then select "Check Out"

6 Checkout

IMPORTANT "WATCH OUT:: By default, with Office 2007, users have the option to "Use my local drafts folder". I have seen nothing but problems with this feature. Files essentially get cached locally for offline editing. But this often causes conflicts when there are multiple users editing files. What's worse is the check box is "on" by default. I have had situations where I had to rename the file in the library in order to fix conflicts with this. Instruct your users not to use this feature!

7 Turn Off Local Drafts

Notice the "Checked Out To" field that we exposed when we modified the All Documents view now shows who the document is checked out to. Note also the little green downward pointing arrow on the document icon. This is a visual cue that the document is checked out.

8 Checked Out To

When editing Office documents, there is an option on the document name dropdown that says "Edit in Microsoft Word". Though you should be able to click on the document to open it...I've seen situations where users have issues clicking on it for editing purposes. The dropdown option works reliably.

9 Edit in Microsoft Office Word

After saving the document, when you go to close the document you are prompted "Do you want to check in now?" (Clicking "No" keeps the document 'checked out'.)

0 check in now

After clicking "Yes" to check the document in, you are prompted for an optional comment.

1 Check in comments

The most recent check in comment is displayed in in the field.

2 library shows last comment
Next Steps
  • Check out MSSQLTips.com for great information about Microsoft SQL Server.


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



Comments For This Article

















get free sql tips
agree to terms