2013-08-19, 13:59 #1
- Join Date
- Sep 2006
- New York, New York, USA
- Thanked 0 Times in 0 Posts
Office 2010: Export Project to Excel and Retain Formatting
I have a MS Project 2010 Pro project that I want to export to Excel 2010 Pro, but would like to retain the "formatting" of the project plan. So all task indents, etc. I tried exporting the project with and without maps, but cannot seem to export to Excel without all tasks treated as the same level regardless of their actual level numbers. I realize that Excel will not work the same as Project and that some of the look and feel will be different, but I didn't expect a flat list of tasks and loss of anything to indicate summary info.
Searching the net turned up some clever Excel formatting trick to simulate this formatting, but I was hoping for something native. I also tried Office 2013 and Project 2013, same results.
Anyone know of some way to get Project to export while retaining formatting? I can use a PDF export for read-only needs, but also need an editable version for others to make changes to, hence the desire to retain formatting. If another app, like Word, can work better than I will consider that as well.
Thanks for the always great help from fellow "Lizards".
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!