on Mar 16, 2020Article Content
| Article Number | 000038561 |
| Applies To | RSA Product Set: RSA Archer RSA Version/Condition: 6.4.x and older |
| Issue | In 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. |
| Cause | In 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). |
| Resolution | Upgrade to version 6.5 or newer. |
| Workaround | When exporting from 6.4.x or older, export to CSV (.csv) to see all content records from the report. |