ms project professional, share resources

Posted on 2014-08-19
Last Modified: 2014-08-20
I have one resource pool file with resources.
I want to give a resource a max percentage in this file. For example 100%.
Then I have a number of project files.
In these projects I want to give the same resource a limit for each project.
For example; Project 1: 50%. Project 2: 25%.

I have tried to find out how to do this, but I only find how to change max percentage in the resource pool which make the same change in the project files, and how do it the other way around. A change in one side is distributed to the other.

But I want to be able to give one resource a max in the resource pool and then offer another max to each project.

Is this possible?
Question by:barges
    LVL 12

    Expert Comment

    Sorry, this is not possible. When using a resource pool file, this always takes precendence and overwrites whatever you set in single project. BTW, this also doesn't work if you use Project Server - would be very helpful in real life.


    LVL 47

    Expert Comment

    I agree, this is what I had always believed was the case. No points pl.

    Author Comment

    So the only way to solve this is to divide the resource into one for each project and set the max for each?
    Like Bill_proj1, Bill_proj2, etc.
    LVL 12

    Accepted Solution

    No, but you can just add "Bill" to every project where you need him, set the max units as needed and DON'T use the resource pool file. However you'll lose the ability to see cross project usage of your resources...there's only one way to die.

    If reporting is enough you can export timephased usage data to Excel, consolidate all the files (one per project) and build a pivot table/chart there.

    Author Closing Comment

    Thank you thausla!
    I am surprised about the limitation in MS Project. I though this was an important piece when planning resources for more than one project.
    I accept your answer and will discuss your idea about consolidating Excel files with the project leader. The problem is that there are a large number of projects involved.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    In this article I will provide some simple productivity hacks that will help you use Google to specifically show results from any web site ( in my example), with minimal effort in Chrome and Firefox. I've seen a common theme a…
    Companies keep a much closer eye on costs today, so changing to new Technology – Microsoft Office 365 is the smartest move to take.
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now