Downloading Clean MReports to Excel

Summary

Formatting reports for the web pages can add extra rows and columns when downloaded to Excel. Hyperlinks aren't necessary when using the data in Excel, so these are removed using this process.

Body

Environment

MReports

Issue

How do I download an MReport to Excel without hyperlinks and extra blank rows & columns?

Resolution

  1. Open the desired report in MReports.
  2. Click on the "No-Link Format" hyperlink located above the column headings. This action removes hyperlinks from the report.
  3. Once the hyperlinks are removed, click the Disk icon in the report controls to download the report in Excel format.
  4. The downloaded Excel file should now be free of hyperlinks and have the correct formatting without extra blank rows and columns.

Additional Information

For more details on managing reports and downloads in MReports, please refer to the MReports user guide or help section.

Need additional information or assistance? Contact the ITS Service Center.

Details

Details

Article ID: 12259
Created
Tue 6/18/24 11:59 AM
Modified
Tue 6/18/24 5:43 PM