Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2001
    Location
    Dallas, Texas, USA
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Export MS Project (XP) data to Excel (XP) (WinXP)

    Sub-tasks in MS Project are indented below the major task. When I export the Project to Excel, the indentation is lost...all tasks are aligned the same in the column. Is there a way in Project or some "save-as" Excel template that would preserve the indentation of sub-tasks?

    As always, I appreciate your taking your valuable time to respond. <img src=/S/help.gif border=0 alt=help width=23 height=15>

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Export MS Project (XP) data to Excel (XP) (WinXP)

    Nick,

    There is no easy way that I know of to get the tasks to indent as project indents them when exporting to excel. There are, however, some options that you might try.

    1. Insert 5 spaces in front of each subtask name. Thus, when exporting to excel, you will get the spaces and the tasks will "appear" to be indented.
    2. Use a text field and input a "s" for each subtask. Export the text field to excel with the other data. Use a search and replace in excel where the text field = "S" to insert spaces to make it appear that the indents are there.
    3. Using the "s" in a text field as in 2 above, write an excel macro that moves all of the subtask cells one to the right where an "s" is present in the text field so it appears to be indented.
    4. If you are just trying to "view" the data, copy and past link the data as a picture in excel.

    Just some ideas.
    Regards,

    Gary
    (It's been a while!)

  3. #3
    New Lounger
    Join Date
    Apr 2001
    Location
    Dallas, Texas, USA
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Export MS Project (XP) data to Excel (XP) (WinXP)

    Tks very much for the reply Gary. I'll give your ideas a try. <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •