98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Project Training and help » Importing to project
Importing to project
Resolved · Low Priority · Version 2007
David has attended:
Project Introduction course
Importing to project
If you had indented tasks in excel, will they be imported as summary tasks
RE: Importing to project
Hi David
Thanks for your question. In short no, the import process doesn't automatically pick up on indents in Excel. The way to achieve this would be in Excel to create a column called Outline Level and use it to indicate how indented an item should be. For example the an Excel sheet with two columns
Column A:
Outline Level
=========
1
2
2
1
2
Column B:
Name
====
A summary
A sub task
Another sub task
A new summary
That also has a sub task
Will result in a plan that looks like this:
A summary
A sub task
Another sub task
A new summary
That also has a sub task
To import the sheet in Project choose File > Open and set the text type to Excel and follow the wizard.
I hope this helps - do let us know if you have any further questions.
Kind regards,
Andrew
Thu 19 Feb 2009: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Keep constraining dates to a minimumAs far as possible avoid fixing the dates of your tasks. For example try to steer of clear dragging task bars in the Gantt chart to move them on the timeline or entering dates directly into the Start / Finish fields. |