Export to Excel

Access: DMP Administrator

 

At any point in the development of a DMP, a DMP Administrator can export the DMP into a Microsoft Excel spreadsheet using the Excel button on the View My DMPs and Search All DMPs windows. Also, the Excel button appears in the Header on the Edit DMP window.

 

NOTE: Only DMP Administrators have access to the export to Excel functionality.

 

From the View My DMPs/Search All DMPs Windows

To export to Excel from the View My DMPs or Search All DMPs windows, complete the following steps:

 

  1. Click once in the DMP row in the table. The DMP will be highlighted.

  2. Click the Excel button. A message displays asking if you would like to export the DMP. Click Yes.

  3. Select the location of where the file should be saved on your local machine and click Save. You can choose to keep the file name provided or save the DMP with a new file name. Make sure that the file extension remains ".xls" (for Excel).

  4. Once the export is complete, a confirmation message displays. Click OK.

  5. Locate the file on your machine and open it.

  6. The electronic DMP will open in an Excel spreadsheet.

 

From the Edit DMP Window

From the Edit DMP window of the selected DMP, click the Excel button found in the Header of the DMP and follow the above instructions (see graphic below). (Refer to DMP Window Layout for an explanation of the Header.)

 

NOTE: Any changes made to the DMP in the Excel spreadsheet must also be made in the application. In this release of the DMP module, there is no way to upload the updated/modified Excel back into the application.

 

 

See Also

Print DMP