Exporting Data from Report Objects to Microsoft Excel 2007

Issue: An error occurs when data from a report object is exported using the Export to: Excel 2007 Workbook (*.xlsx) option or when there are character codes displayed in the exported Excel file.
Resolutions:
  • If an error occurs during exporting, then in the Export or Save As window, select either the Save as: Tab-Separated Values (*.tsv) or the Save as: Comma-Separated Values (*.csv) option to create a data file.
  • If you see character codes displayed in a file that has been exported to Excel, then re-open the exported file in Excel, and save it without any changes. The character codes are removed from the file.