If you manage multiple projects using Microsoft Project and you use common resources on some or all of them, you know how difficult it is to resolve resource overallocation. Here is one simple trick—use a blank resource pool.
Assume that you have Project A and Project B.
- Create a blank Microsoft Project file and call it “Resource Pool”
- Open Projects A and B
- Select Window / Arrange All to see all open files
- Select Project A and click on Tools / Resource Sharing / Share Resources
- Select “Use resources” from “Resource Pool” and “Pool takes precedence”, and then click on OK
- Repeat for Project B
- Switch to the Resource Pool and click on View / Resource Usage
- Insert the Project column to see which project is causing the over allocation