![]() ![]() In the Export Wizard - Map Options dialog box, tick Tasks and Export includes headers then click Next. Just like Primavera P6, Microsoft Project also allows export of Tasks, Resources and Resource Assignments but in this tutorial we are only going to export Tasks. ![]() In the Export Wizard - Map dialog box, tick New map and then click Next. In the Export Wizard dialog box, click NextĪnd in the Export Wizard - Data dialog box, tick Selected Data option and then click Next To export to Excel in Microsoft Project, go to File > Save as and from the Save as type dropdown box, select Excel Workbook(*.xlsx) and then click on Save button. Unfortunately Microsoft Project does not have the option to right-click and export to Excel. To export in Primavera, right-click anywhere in the Activity Table and click Export to Excel and save the Excel file.Īnd the newly created Excel file looks like a proper Excel Table as shown below. In Primavera P6, exports to Excel come formatted as an Excel Table for any data analysis you might want to carryout but with Microsoft Project, you still need to format the Excel properly prior to any Excel Table data analysis. If you have ever used Primavera P6, you would be surprised that exporting from Microsoft Project to Microsoft Excel does not provide you with a ready to be used data considering that both products are from the Royal House of Microsoft.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |