000038561 - Exporting a report to Excel (.xls) with over 65K records in RSA Archer does not output all records

Document created by RSA Customer Support Employee on Mar 16, 2020
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000038561
Applies ToRSA Product Set: RSA Archer
RSA Version/Condition: 6.4.x and older
IssueIn 6.4.x or older, exporting to Excel (.xls) does not include all the data if the report has more than 65,536 content records. 
CauseIn 6.4.x or older, exporting to Excel (.xls) used the Excel 2007 format and there was no option to export using .xlsx format.  

Starting with 6.5, Archer was enhanced to export to XLSX file format that allowed more rows and columns to be in an Excel file.  The "Big Grid" increases the maximum number of rows per worksheet from 65,536 to over 1 million, and the number of columns from 256 (IV) to 16,384 (XFD).
ResolutionUpgrade to version 6.5 or newer.
WorkaroundWhen exporting from 6.4.x or older, export to CSV (.csv) to see all content records from the report.