Exportar dados do MS Project para o Excel

Question

Estamos usando o MS Project 2003 e o MS Excel 2007.

Gostaríamos de exportar dados da tarefa do Project para o Excel. Alguém sabe como fazer isso?

    

Answer 1

De escritório. microsoft.com :

Export timephased (or timescaled) project data to Excel:

If you want to display timephased (or timescaled) information in a Microsoft Office Excel 2003 graph or chart, you can export it using the Analyze Timescaled Data Wizard.

1. On the View menu, click Gantt
2. If applicable, select the tasks you want to export.
3. On the View menu, point to Toolbars, and then click Analysis.
4. Click Analyze Timescaled Data in Excel.
5. Following the Analyze Timescaled Data Wizard instructions, click the fields you want to export to Excel.

To learn other ways to export data from Project, see the related links in the See Also box, which is visible when you are connected to the Internet.

Notes:

• Timescaled information is also known as timephased information.

• If you don't see any information exported, then you may not have
  specified which fields to use in the
  wizard. Re-run the wizard and select
  the fields you want to export in step 2 of the wizard.

• The wizard does not export resource assignment information.

Você também pode querer verificar este link: Exportar dados do projeto para outro formato de arquivo .