Share via

Export Microsoft Project 2013 Task Usage and Resource Usage reports to Excel that includes the WEEKLY TIME SCALE

Anonymous
2017-03-02T17:34:53+00:00

Hello,

I've spent many hours trying to Export Microsoft Project 2013 Task Usage and Resource Usage reports to Excel that includes the WEEKLY TIME SCALE. Does anybody have any suggestions?

Thank you

Philip

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. John Project 49,710 Reputation points Volunteer Moderator
    2017-03-02T21:33:14+00:00

    Philip,

    Basically there are three ways to get the Project Usage view information into Excel. The first is with a simple copy and paste. It's not elegant but it works. The second is as Julie suggested, via the Visual Reports. The third is with VBA. Personally I prefer VBA due to its total flexibility but if you are familiar with Excel pivot tables then Visual Reports may be a better choice.

    John

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-03-02T19:22:40+00:00

    Have you tried the Visual reports?  It will create a pivot table in Excel.

    Was this answer helpful?

    0 comments