Save as/Open Excel with Project 2007 causes misalignment of tasks. RRS feed

  • Question

  • In an attempt to export specific activities for field updates, I use the Save As function to Excel Workbook - mapping: Unique_ID, ID, Name, Start_Date, Finish_Date, Actual_Start, Actual_Finish (Unique_ID being the mergekey)

    Once the field returns the Excel Workbook, I open it using the same map. Once I merge the updated fields into the Project - all activities gets the update belonging to the activity following (shifts up)

    Running several tests - I find that running the merge again - corrects the problem! It also seems to be related to the opening of the project file - ie. if I save the map in Excel, do the updates in Excel, and merge the file, without closing the file/Project it works OK. On the other hand if I save and close Project - reopen project and file - the error seems consistent with the initial merge!

    I have corrected my merge macro to reloop, but I am worried that my project file becomes corrupted.

    I have updated my Project 2007 Professional running SP2 -


    Rgd Michael

    Thursday, April 14, 2011 9:16 AM