Identifying Resource Calendar Exceptions with Project Professional

I delivered a Microsoft Project Professional tips and tricks session a while back, and that may have gotten me thinking about other tricks that I’ve got buried deep in the recesses of presentation topics folder.

This post addresses a question that appears on the Project newsgroup every now and then, i.e. how does the project manager get an easy to use overview of all calendar exceptions for resources assigned to a project.  This technique is applicable to any version of Microsoft Project that I’ve ever worked with – and works equally well with standalone or enterprise files.

First, let’s take a look at how you find and set the calendar exceptions.  Navigate to the resource sheet….


…double click on a resource and select the option to Change Working Time.  This will display the exception screen.


That may be difficult to do for each of the resources in a project schedule – especially because in a Server environment, the Admin may be adding exceptions to the resource pool and neglecting to notify us.  We need a method to generate a single list of all exceptions.

The solution is quite easy.  Simply go to the Project tab and click on the Reports button.


Pick one of the Assignment reports and click on the Edit button.


In the Details dialog box, add the Resource calendar data.  Click OK and then select the report.


…and you have a handy report listing all calendar exceptions:


Identifying Resource Calendar Exceptions with Project Professional

2 thoughts on “Identifying Resource Calendar Exceptions with Project Professional

  1. […] Identifying Resource Calendar Exceptions with Project Professional un ottimo articolo che ci mostra la soluzione ad un problema comune nella gestione delle risorse di progetto e che mostra il livello di conoscenza dell’autore su Project. Il report che viene costruito nell’articolo permette di evidenziare le risorse che hanno eccezioni nel proprio calendario (giorni di malattia pianificata, disponibilità limitata della risorsa in un certo periodo e così via) e che non sono immediatamente visibili analizzando sia il Gantt che l’elenco delle risorse. Questo problema viene amplificato se le risorse sono allocate a più progetti gestiti da più project managers sia con Project Professional (Pool di Risorse) sia con Project Server. […]

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s