importing %complete from excel

[D Pingger]

In 2003, I'm updating data using an excel spreadsheet but for some reason,
the %complete value doesn't import back in. Is there something I'm missing?

I use the import wizard and mapping.

Help!

TIA
DPingger

 

[JulieS]

Hi D Pingger,

What other data are you importing? It may be possible that you have
data being imported which conflicts with the % complete. For example,
if you try to import % complete but also import actual and remaining
duration, the percent complete field is going to be recalculated by
the actual and remaining duration values.

Percent complete = (actual duration/duration)*100

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[D Pingger]

Thanks, Julie.

Nope, the only thing I'm importing is a number that goes into Number9 field,
a date that goes into Date9 field and the % complete.

For some reason, it imports the other two but ignores the %complete value.

Any ideas?

Thanks

DPingger

 

[D Pingger]

Hi JulieS,

I tried just importing the % complete field (deleted the other two fields
from the file) and it still wouldn't do it. Hmmmmm. I'm way stumped now.

Help!?!?!?!?!

DPingger

 

[John]

Hi JulieS,

I tried just importing the % complete field (deleted the other two fields
from the file) and it still wouldn't do it. Hmmmmm. I'm way stumped now.

Help!?!?!?!?!

DPingger

DPingger,
Pardon me for nosing in. How is the percent complete value expressed in
Excel? If it is just a number, (i.e. 60 for 60%), Project will not
recognize that format and will import 0%. However, if it is expressed in
Excel as a percent or decimal, (i.e. 60% or .6), then it will be
imported.

John
Project MVP

 

[D Pingger]

WHOA!!!!!!

Thanks for nosing in, John!!!!!

What a simple answer! Yes, I made the fix and it now works. I only had the
column formated as a number; changed it to a % format and everything works.

This board rocks because of experts like Julie and You!

Thanks again for caring about users problems like me.

DPingger

 

[JulieS]

You're most welcome D Pingger. And thanks for the "nose" in John --
great catch

Julie

 

[John]

WHOA!!!!!!

Thanks for nosing in, John!!!!!

What a simple answer! Yes, I made the fix and it now works. I only had the
column formated as a number; changed it to a % format and everything works.

This board rocks because of experts like Julie and You!

Thanks again for caring about users problems like me.

DPingger

D Pingger,
Let's see, we band together as MVPs to help the users and you say that
we rock. I guess that makes us a rock band

You're welcome. Sometimes I just get lucky.

John
Project MVP