summary task % complete calulation when subtask link to Excel

[treyn1292]

I have 3 subtasks linked to an Excel worksheet. They are all porgressed to
100%. The summary task in Project shows 99% and should show 100%.
How can I get the summary task to show 100%?

Office 2003.

 

[John M.]

Do you happen to have a milestone within the summary task? If so, try
setting it to 100% complete as well.

John

 

[treyn1292]

Thanks for your post.
No, there are only the 3 tasks. I did find that not linking the summary
task % complete to the excell spread sheet (even though that link was to a
blank cell) allowed Project to correctly calculate the % complete. I did
have to adjust the summary task manually, then change the 'feeder' cell, to
get the correct summary %. This just makes for more cut / paste special
steps, but it will work.