Info_Table provides general instructions for using this workbook (see Figure 17-24). The workbook is created with four worksheets of discrete information: Task_Table, Resource_Table, and Assignment_Table. To open and review your exported project data in Microsoft Excel, follow these steps:ġ In Microsoft Excel, open the Excel file. Your data is saved as a complete Excel workbook. To create a complete Excel workbook of project information from your project file, follow these steps:ġ In Microsoft Project, open the project whose information you want to export to Excel.ģ Browse to the drive and folder where you want to save your information.Ĥ In the Save As File Type list, click Microsoft Excel Workbook (*.xls).ĥ In the File Name box, enter a name for the Excel file and then click Save.Ħ On the Export Wizard Welcome page, click Next.ħ On the Data page, click Project Excel Template and then click Finish. With this method, Microsoft Project organizes data into Task, Resource, and Assignment data types, which in turn are presented in their own separate worksheets in the single Excel workbook. You can export more complete information about tasks, resources, and assignments.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |