Using Master Sheet and calculating correct costs from sub tasks

K

Kimi Himi

Good Day. We have five departments. Each department has their projects in
separate files. Each of their projects roll up into a dept-master. The
owner of the company then has a MASTER project that each of the
depart-masters roll up into.

When you first open the MASTER project, the total cost is listed (we roll up
all cost fields). However, when you open the first departments dept-master
the total cost changes. You then must open every single sub-task in the
MASTER for the total to recalculate. It's nuts. I must have something set
wrong. I have the same problem with the dept-master.

How can I always get Project to calculate the entire set of sub projects? I
have check the options menu but that doesn't help.

Thanks in advance. Kimberly
 
G

Gary L. Chefetz \(MVP\)

Kimi:

The calculation can't occur until all the files are open. Project Server
might be something the owner of the company should consider.

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

-
 
K

Kimi Himi

Thanks Gary, we own Project Server. We are still struggling with
understanding how it works. Can you direct me to specific topics for
researching this problem.

Thank you so very much! You're valued!

Kimberly
 
G

Gary L. Chefetz \(MVP\)

Kimi:

This kind of analysis can be done in the Portfolio Analyzer or in the
Project Center, provided you have seeded the database with the outline codes
you need.

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

-
 
Top