How to import Start/Finish Data from Excel

E

evgeneiac

I am appending existing projects that have been managed in Excel to a MS Project file. I would like to show the existing start and end dates that exist in Excel. These fields map fine in the Wizard and preview looks perfect. However, on import I get blank (actually blue) fields under Start, Finish and Duration.

If I import the data in to a NEW project, everything imports as expected.
 
E

evgeneiac

It's interesting that I can copy/paste from Excel to this project with no problem except that Duration does not calculate.

FYI, the source Excel doc looks like
ID Name Duration Start Finish Resource Names Notes
12 AAAC 10/25/2013 11/1/2013 Note 1
13 BBB 10/28/2013 11/01/2013 Note 2
24 CCC 11/3/2013 11/04/13 Note 3
15 DDD 11/1/2013
 
Top