Baseline1 estimated finish - export to excel - data disconnect. - MSProject 2010 SP1

[stct]

Greetings!
I am a new member to this forum, and saw really good discussions in the subject area. I need some help on data disconnect after exporting into the excel format.

We are finding some disconnect on the data in the field 'BaselineX Estimated Finish' - after saving the project in an excel file. It seems, some of the date values in 'BaselineX estimated finish' after exporting into excel are showing a different date value.

For example, in the MSProject file, the 'Baseline1 Estimated Finish' date for one of the task = May 31 2013. Where as the same task's field value shows June 4 2013 - after exporting the file into an excel format.

Unfortunately, the similar field value 'BaselineX Finish' (without the 'ESTIMATED' tag) - although exporting with the correct value - does not help. The format in 'BaselineX Finish' field value includes a time stamp - which could not be reported through a pivot of excel.

Any advise would be very helpful!

Thank you!

 

[JulieInMaine]

Please do not post the same question to multiple forums. This is the third location you've posted to. I've answered you at:

http://answers.microsoft.com/en-us/...cel-data/81a72a76-25b7-40c4-a376-3be05eae22a0