exporting excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Project Training and help » Exporting to Excel

Exporting to Excel

resolvedResolved · Low Priority · Version 2007

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?

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.


 

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


Server loaded in 0.09 secs.