Solved

MS Project export

Posted on 2014-02-08
1
659 Views
Last Modified: 2014-02-25
I have MS Project 2013 and I'd like to know if it is possible to keep the same format of my Gantt chart when export to Excel. Basically, I have the task names with summary task names and I'd like to keep in that way when exporting to Excel. But it did not work for me. All I got was a list of all the tasks and it is hard to read. Thanks
0
Comment
Question by:leblanc
1 Comment
 
LVL 19

Accepted Solution

by:
regmigrant earned 500 total points
ID: 39849756
This is standard behaviour and I'm not aware of any way to change it - I did have a play about creating new maps and so on but the intention seems to be that you use the 'outline level' column to reformat. level 1 is summary tasks, 2 the level below etc

Once you have the export you can use Conditional Formatting to change the text of summary items to Bold, first level items to (for example) a smaller font and third level items to italics  based upon the outline level and so on.

Alternatively you can use autofilter on the outline level and manually apply a cell style to the tasks that are filtered in this way. This has the advantage of allowing a change to the Alignment - ie: you can add a left indent - which is not available in conditional formatting - in the attachment: filter on level 2, select all tasks names and choose 'style 1' from the cell styles drop down

A third option is to put the data into a pivot table and use the various formats in there to achieve what you want - however the most useful view for that seems to have been deprecated in 2013 so its not as flexible as it was
test.xls
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
IT Asset Management 5 69
People Counting Software 2 113
Software that will scan Windows license from external disk. 2 45
Google Sheets Script 21 57
I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
The viewer will learn common shortcuts with easy ways to remember them. The viewer will then learn where to find all of the keyboard shortcuts, how to create/change them, and how to speed up their workflow.
The viewer will learn how to successfully download and install the SARDU utility on Windows 8, without downloading adware.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now