percent complete from xls to P5
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
after a buncha tries, it seems that the problematic activities have a duration with an odd decimal, like 2.5 hrs.
apparently it works just fine with activities like 2.6 hrs.
strange.
if this may help...
in fact every activity is set on "duration".
Ill look forward to the "duration (or physical) percent complete", but Im pretty sure these fields are marked with an asterisk... doesnt this mean that these fields cannot be updated by excel ?
thanks anyway for the answer.
I think your problem is that you are exporting the field Activity Percent Complete and you have the Percent Complete Type set to "Units" instead of "Duration" or "Physical" for the activities that are not working properly. The ones that work are most likely set correctly.
I find it better to use the appropriate percent complete field (Physical, Duration, Units) rather than Activity Percent Complete, since that field will show different information depending on the activity settings.
BTW, thats also why Activity Percent Complete doesnt roll up in Layouts.
Ian
http://www.emerald-associates.com