SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm in a process where I'm copying documents from a SharePoint 2003-site to a new 2007 site. The problem is that documents that are checked out on the 2003-site are not copied in their newest version (the checked out version).

We have many folders and documents and hence wonder: is there an easy way (preferably using the web user interface) to list all documents in a document library that are checked out to somebody?

Please let me know if you know how this can be done, or if you can point me to a previous post that can help me.

share|improve this question

NO-Code: Try building a view that ignores Folders and filters out by the CheckOut To column not being NULL - this means actually the document is checkout.

share|improve this answer
Hi, this worked out well for me although I had to export to excel and filter on checked out != (blanks) in excel as there was no option in SharePoint view to filter on checked out column. Thanks a lot! – Terje L Apr 24 '12 at 8:18
I also used the NO-Code (New View) suggestion, and it worked great for me. I used a filter of >= a, which seemed to work and bring back all the checked out files. Using the >=a trick avoided the Export to Excel step. – user27157 May 27 '14 at 14:45

You can get the list of checked out items from Content and Structure reports from 2007 and 2010. Visit this blog or this msdn post on the steps to accomplish this.

This is an out of the box feature which should be available if you have publishing feature enabled in your site. I am not quite sure about SharePoint 2003 site though. You might have to try it out.

Basically the report uses the below CAML query to retrieve all the documents that are checked out -

<Where><IsNotNull><FieldRef Name="CheckoutUser" LookupId="TRUE"/></IsNotNull></Where>

share|improve this answer
Thanks for your answer! However I tried C. Marius' method first as this seemed easier and this turned out to work well, so did not try your method. – Terje L Apr 24 '12 at 8:21

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.