Exporting to Excel

Resolved · Low Priority · Version 2007

Tue 20 Sep 2011, 16:06 Delegate Gaynor said...

Gaynor has attended:
Project Intro Intermediate course

Exporting to Excel

Is it possible to export outline levels so that are recognised by Excel as sub-totals and/or sub-headers?

Wed 21 Sep 2011, 21:50 Trainer Rodney said...

RE: Exporting to Excel

Hello Gaynor,

Hope you enjoyed your Microsoft Project course with Best STL.

Thank you for your question regarding exporting to Excel.

Unfortunately, when exporting to Excel from Project, outline levels are not preserved and therefore no sub-totals are created. The same situation applies when importing from Excel to Project... all outlines and sub-totals are not preserved.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Wed 28 Sep 2011: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

MS Project tip:

Link tasks using predecessor column - project

a. First, note ID number of the task you want to link to (predecessor). Then, in the predecessor column of the task you want to link to (successor), type the predecessor task's ID number.
b. The link will be a Finish to Start (the default type).
c. Or you can add in a code for a different relationship type
i. SS = Start to Start
ii. FF = Finish to Finish
iii. SF = Start to Finish
d. You don't have to type the task ID numbers in any specific order, but you must separate multiple tasks with commas.

View all MS Project hints and tips