Copy and paste resource spreadsheet data to Microsoft Excel

  1. Choose Project, Resource Assignments.
  2. 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.
  3. In Excel, right-click in the spreadsheet, then choose Paste.

    Note:

    • 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.