data export to excel

[Irene]

Is there anyway to efficiently export hours from the calendar columns in the
resource usage view directly to an excel spreadsheet. It appears these
columns can't be mapped and cut and paste is way too slow.

 

[John]

Is there anyway to efficiently export hours from the calendar columns in the
resource usage view directly to an excel spreadsheet. It appears these
columns can't be mapped and cut and paste is way too slow.

Irene,
Well, the most "efficient" way to do that is via a VBA macro. Other
options are available but they are less efficient.

You don't say which version of Project you are using. If it is 2007 you
can use the Visual Reports feature found under the Reports menu. It will
export the timescaled data into an Excel Pivot table. If you are using
an earlier version of Project, you can use the "Analyze Timescale Data
in Excel" add-in which can be accessed via the Analysis toolbar.

Hope this helps.

John
Project MVP