Hi, can someone explain me how could I export to Excel a table that contains
exaclty the information showed in the Task Usage view?
The purpose is to view the workload for each resource by each task
(distributed in days/weeks - the yellow columns data).
Guilherme,
To export the information exactly as shown in the Task Usage view
requires a custom VBA macro. However, there are some alternatives that
can get close. Using a combination of an export map and the utility,
"analyze timescale data in Excel", the data shown in the Task Usage view
can be exported piecemeal and then re-assembled in Excel. An export map
is needed to export the static data (data on the left side of the Usage
view) and the utility is needed to export the timescaled data. What you
will not get with the utility is the timescaled data for summary lines,
but that data can be re-created in Excel with some formulas.
All in all, the best bet and most flexible solution is the custom macro.
Hope this helps.
John
Project MVP
