Greetings!
We are on MSProject 2010 Professional - version 14.0.7015.1000 (32 bit).
Noted following issue while exporting MS Project Task data (through Map and save as excel 97-2003 type.
When exporting Baseline1 Estimated Finish date field, it has a different value exported intoexcel, than one in the MS Project file for the same field.
In order to avoid this problem, if we rely on Baseline1 Finish date field, the value exported into excel does match to the MS Project file. However, we can not use the Date Value function (formula) on this field, as it gives an #VALUE! error output on all the cell, when pointed to the exported Baseline1 Finish date field.
Is this something related to the version? When we were using 2007 or earlier version, (when Baseline1 Estimated finish was not introduced) . we never experienced this problem of data disconnect..
Thank you in advance for suggestion!
We are on MSProject 2010 Professional - version 14.0.7015.1000 (32 bit).
Noted following issue while exporting MS Project Task data (through Map and save as excel 97-2003 type.
When exporting Baseline1 Estimated Finish date field, it has a different value exported intoexcel, than one in the MS Project file for the same field.
In order to avoid this problem, if we rely on Baseline1 Finish date field, the value exported into excel does match to the MS Project file. However, we can not use the Date Value function (formula) on this field, as it gives an #VALUE! error output on all the cell, when pointed to the exported Baseline1 Finish date field.
Is this something related to the version? When we were using 2007 or earlier version, (when Baseline1 Estimated finish was not introduced) . we never experienced this problem of data disconnect..
Thank you in advance for suggestion!