Troubleshooting: Error when export grid ledger to excel – Specified argument was out of the range of valid values.
Question: When I try to export grid ledger to excel this error message is prompted ‘Specified argument was out of the range of valid values. Parameter name: Maximum number of rows exceeded (XLS format). Reduce the number of rows or use XLSX format’. What does it mean?
Version: 1.8 / 1.9 / 2.0
Possible Reason :
You are using “Export to Excel 97-2003’’ and your total number of records (154033 records) is exceeding its limit.
Excel 97-2003: column and row limit (256 columns & 65,536 rows).
Choose “Export to Excel”. You should be able to export.
By: Aimi 210716, Lay Swan 210726, P210727
|AutoCount Accounting 2.0
|AutoCount Accounting 1.8 / 1.9
|AutoCount On The Go
|AutoCount Accounting Plug-In Documentations