Loading...
Quick Links

Ask the Experts: When % Complete Won’t Calculate

Nancy asks, “I have been a project controller for about seven years. I have a problem that I cant figure out. My % Complete column has stopped calculating. Also, the Actual Duration and Remaining Duration are not being updated either. Actual Duration is always zero even though its well into the task. So Remaining Duration equals Duration. What would cause that?”

Answer: This one is really puzzling. After reviewing the MPP file sent, I wasn’t able to see why the % completed doesn’t calculate. I have checked the settings which, are all fine. Then I exported the project into an XML file and re-imported it ( just in case the schedule is corrupt); but this didn’t change the behavior (which is a bummer).

I’ve also noticed that some % completed updates actually work. Task 31, for example, works fine, but Task 3 doesn’t work at all in regards to the % complete. It seems that a combination of settings and corruption could create this effect. So here’s how I suggest you make it work. (I assume this isn’t a Project Server environment, but only an MPP file.)

1. Save the project as an XML file.
2. Open the XML file in Microsoft Project and create a new project.
3. Go to tools | option. Within the Calculate Tab select “Updating Task Status updates Resource Status.”
4. Save the project.

Nancy replies: “Well, thank goodness! It’s in a Project Server environment, so I skipped steps 1 and 2. It still worked. Thank you so much!”

 

 

Share This Post
4 Comments
  1. I had the same problem and this solution solved it. Mine was also in Project Server so I did what Nancy did and it worked.

    Thanks!

    Reply
  2. Thanks for the assistance. Your post helped a lot. I wasn’t displaying the column on my project plans due to not being able to get this to work, and was using TFS to update progress on the project.

    Reply
  3. When I try to open the xml file in MS Project the program crashes. Does this mean the file is corrupt?

    Reply
  4. I figured out why the %complete is not changing. I created custom fields for the duration, actual duration and remaining duration so that I could get the summary tabs to sum the hours correctly. When I did that it caused the %complete to not work. Is there anything I can do to fix it other than taking out the custom fields?

    Reply

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Please complete this equation so we know you’re not a robot. *

Thanks for submitting your comment!
You must be logged in to comment.