none
Export timephase data to Excel RRS feed

  • Question

  • Is there a way to export task usage data exactly like what I see on the screen to Excel? I know Microsoft recommends to use Visual report to export any timephase data; however, the exported data is in pivot table, not a simple Excel format like how I map data through "Save As in Excel".
    Friday, November 4, 2011 4:48 PM

Answers

All replies

  • Mimi,

    The answer is yes but to do so requires VBA. Before the Visual Reports feature was added, Project had a utility called, Analyze timescaled data in Excel. It didn't exactly replicate what you see in the Usage views but in my opinion it was easier to use than visual reports and pivot tables. Unfortunately that utility is no longer available in Project 2010.

    As I said the best option for full flexibility is VBA. Using that you can get any format you wish of Project data in Excel. If you are interested in learning VBA, MVP Rod Gill has an excellent book on the subject. For more info go to, http://www.projectvbabook.com

    Hope this helps.

    John

    Friday, November 4, 2011 5:17 PM
  • Mimi --

    Assuming you are using Microsoft Project 2010, then no, there is no default way to export task usage data to Excel so that it looks like it does in the Task Usage view.  Knowing that a Visual Report does not meet your reporting requirements, the only way to export the timephased data the way you want is to write a macro using the VBA programming language.  Hope this helps.


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Friday, November 4, 2011 5:17 PM
    Moderator
  • I'm currently using MS Project 2007. What will be an option for me?
    Friday, November 4, 2011 5:38 PM
  • Mimi,

    Unfortunately the same response applies. The Visual Reports feature was introduced in Project 2007 and the utility I mentioned was removed.

    John

    Friday, November 4, 2011 7:22 PM
  • Mimi --

    My reply covers both Microsoft Project 2007 and 2010.  Your only choice would be a macro using VBA.  Hope this helps.


    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Friday, November 4, 2011 7:56 PM
    Moderator