Copy and paste resource spreadsheet data to Microsoft Excel
- Choose Project, Resource Assignments.
- Select a row, then choose Edit, Copy.
All associated spreadsheet data, as well as row and column headers and values, will be copied to the clipboard.
- In Excel, right-click in the spreadsheet, then choose Paste.
Notes
- Excel may try to reformat data pasted into its cells. You can reformat the cells as text before pasting your data, or try pasting into a different application.
- Any edits made in Excel will not be returned to the project. This can be used for reporting only.
- If you have any fields with #######, simply expand the column width to accommodate the project information.