Census_workers

Reprinted with permission from the US Census Bureau, https://www.flickr.com/photos/uscensusbureau/

Project Server is a great tool for showing data from multiple projects. In fact, that’s what makes it so good to use when you’re working with a portfolio of projects. In Project Server 2010 there were open source tools you could install called “Solution Starters,” extensions to Project Server that provided additional functionality. One extension was the “Bulk Edit Tool.” This tool allowed the user to select multiple projects in the Project Center View and then click a button and have the ability to edit multiple project-level fields in a datasheet interface.

For anyone who has used Project Server, having a bulk edit capability for projects is a great thing. However, (and, yes, there is an however), using the Bulk Edit Solution Starter is quirky at best and can be frustrating and just not helpful at worst.

So, I have a little trick to help you do bulk editing. And this can be done in Project Server 2010 or 2013 and uses out-of-the-box functionality. Here’s the trick!

1. In Project Server, in the Project Center View, select the projects you want to bulk edit, and then click on Open in Microsoft Project for Editing.

Jean_Lieverman_figure_1

These selected projects will now open up in Microsoft Project Pro as subprojects in a new Master Project.

Jean_Lieverman_figure_2

2. Create a Table/View definition in Microsoft Project Pro that exposes all the fields you’d like to edit. Now you can “bulk edit” all the projects and fields you want.

Jean_Lieverman_figure_3

3. Once you’re done editing, you simply close the Master Project Plan (Project2 in this case), which will also close all the subprojects. The key thing is to answer two questions:

Jean_Lieverman_figure_4

Jean_Lieverman_figure_5

You have just bulk edited all your project plans with all the edits you made in Microsoft Project Pro!