How to import a split task from Excel RRS feed

  • Question

  • Reader Salut!,

    We want to import split tasks from excel. How do we have to notate these split tasks in Excel so they are import correctly in to Project?

    Example we have a task called 'measurements' with a duration of four days. We want to split it in three and one day we a delay of two days.  

    Thxs for your help.

    M. Romijn

    Friday, August 24, 2012 9:05 AM


  • Romijn,

    First we need to agree on the definition of "split task". In Project's world a split task is a single task that has one or more delays in its timeline such that it has multiple starts and stops. Another form of "split task" would be a single task that is split into two or more separate tasks with the delay, if present, included in the link structure. It kind of sounds like your example is the normal Project definition of a split task but I'm not totally sure.

    Assuming you are talking about a normal split task, it cannot be imported from Excel into Project with a simple import map. Importing that type of structure requires VBA.

    Friday, August 24, 2012 3:08 PM