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 |