Exporting data from Resource Usage View to Excel

L

Lee

I'm trying to find an way to export hours found in the Resource Usage View to
Excel. Does anyone know how to do this?

The option found from the defaults (when creating an Excel Workbook File)
does not provide daily values (Monday - Friday) and does not provide daily
hours.

Below is an example of what I want to export.

...............M T W T

Lori: .....8h 8h 8h 8h
Janet: ...2h 8h 0h 8h
Marcus: 8h 8h 0h 8h
 
J

JulieS

Hello Lee,

What version of MS Project are you using? If you are using Project 2003,
you may use the Analyze Timescaled Data in Excel button on the Analysis
toolbar to export that data.

If you are using Project 2007, you'll need to use the Visual Reports or save
the data in a cube file.

I hope this helps. Please post back with further questions as needed.

Julie
Project MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Resource Usage View 2
Proposed tasks being added to resource work load and affecting availability 2
Resource Usage Chart (how to NOT display zero hours worked) 5
% Complete 2
Resource Usage is 0h but expected 8h 1
Resource reporting - name instead of hours/units 9
Task Usage View Customization 0
changes in resource usage view 3

Top