I am using SharePoint 2007 + Windows Server 2008 with SharePoint 2007's publishing portal template.

I find when I edit a couple of pages, I need to check-in/publish/submit for approval/approve one (page) by one (page). Any ideas or solutions to select a couple of unpublished page and submit for publish/approval together?


5 Answers 5


Try this:

  1. Go to Site Actions, Manage Content and Structure.
  2. Click the View menu and change to:
    • Checked Out To Me for drafts that needs to be checked in (unfortunately there is no built-in filter to check for all drafts)
    • All Draft Documents for pages to be published
    • Pending Approval for pages to be approved
  3. Click the 'select all' icon above all of the tick boxes.
  4. Click the Action menu and choose the relevant option.

I have found cases where 'select all' hasn't worked and I've needed to go through each page separately. Still, better than nothing I guess!

  • Thanks Alex! I have tried but seems no way to submit for approval for multiple items in "All Draft Documents"? Here is a screen snapshot, any ideas what is wrong?
    – George2
    Commented Nov 10, 2009 at 12:36
  • Screen snapshot -> i35.tinypic.com/oad8pt.png
    – George2
    Commented Nov 10, 2009 at 12:38
  • 1
    Can't see your screenshot right now because of firewall. The case you've found must be the one that can't be done "en masse" (all together) from the Manage Content and Structure page. I'm sure I've seen a tool or utility that does this. I will look soon and update the answer if I find it.
    – Alex Angas
    Commented Nov 10, 2009 at 12:56
  • 1
    OK I've found this on AC's blog: andrewconnell.com/blog/articles/… which is an STSADM command that will publish all items in a site/site collection.
    – Alex Angas
    Commented Nov 10, 2009 at 12:59
  • 1
    stsadm lives in C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN. Yes you're right it needs to be run from the server. There may well be a CodePlex solution that can do what you need - see what you can find! :-)
    – Alex Angas
    Commented Nov 10, 2009 at 13:56

I believe you can perform a bulk check-in using the "Manage Content and Structure" page (site actions).

  • I tried for quite some time from page "Manage Content and Structure", but cannot find out how. Appreciate if you could share steps.
    – George2
    Commented Nov 10, 2009 at 12:21

Jaap's answer above is right on target. Once you get into the Manage Content and Structure module, you need to navigate through the explorer-like view to the Library where the pages/documents are housed (will show in the right-pane). Once there, mark the checkboxes next to the ones you need to publish/check-in then go up to the action bar above and choose Actions-->Check-In. This will force a check-in of the content. Doing this is especially helpful for those users who bulk upload new documents through the Windows Explorer method and don't want to check-in each document one-by-one.

The only caveat to doing this, as Alex noted, is that SharePoint will sometimes 'ignore' your request because there are required metadata columns that have to be filled out before they can be checked-in. You'll have to update the values, then do the above bulk check-in steps.

  • "there are required metadata columns that have to be filled out before they can be checked-in" -- what do you mean the columns?
    – George2
    Commented Nov 10, 2009 at 14:32
  • 1
    I was just referring to that the Library they are stored in might have columns created that require text entered or a choice from a dropdown list before they can be checked-in. These columns might be Site Columns or created by an admin just for this list. Commented Nov 10, 2009 at 19:13

I have no workflows enabled on lists and am still unable to Approve more than a single item at a time using any of the methods described.

BTW, the Reports views are a part of the Content and Structure tool. There is no distinction here. You can also add your own custom views to the drop-down list via the Content and Structure Reports list (/Reports%20List/AllItems.aspx).

One good example is an All Draft Documents view which allows admins to manage minor versions across the entire site collection. You could create similar views for Check Out state etc.

All Drafts

<Where><Eq><FieldRef ID="{fdc3b2ed-5bf2-4835-a4bc-b885f3396a61}"></FieldRef><Value Type="Number">3</Value></Eq></Where>

I dont think what Jaap said will work for sites with workflow enabled. You are still looking at using command line

open cmd prompt

go to bin folder in the 12 hive and try this

STSADM -o PublishAllItems -url yourURL -list Pages

this gotta work


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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