none
Importing Actual Start and Actual End to PROJECT 2010 from excel 2010 RRS feed

  • Question

  • HI!

    I am importing actuals from excel to project.

    In the excel file I have the list of tasks but some of these tasks haven't got actual start nor actual end. So, when importing, those tasks actuals appear with the actual of other task: in task 3 appear the actuals of task 2. Where task 3 hasn´t got actuals in excel. I need the value N/A in those tasks that actually hasn´t got  actuals.

    I am working in spanish version. Sorry for my english I am writitng from Argentina!!

    Thank you for your attention!

    Silvina




    • Edited by Rdev2017 Sunday, July 21, 2013 8:30 PM
    Sunday, July 21, 2013 8:27 PM

All replies

  • Hi Silvina:

    What you observed is a issue in Microsoft Project and not to do with the way you imported. For tasks without actual, set the dates in Excel to some text like N/A, NA, a space but don't set a date. Projects imports only if the Excel data is compatible with the Microsoft Project field otherwise it sets it Blank. In this case text will not compatible with Actual Start and Actual Finish, and hence it will be set to N/A by default.

    Hope this helps.


    Sai PMI-SP, MCTS Project

    Monday, July 22, 2013 2:40 AM
    Moderator