Troubleshooting: Error when export grid ledger to excel – Specified argument was out of the range of valid values.

From AutoCount Resource Center

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

Ledger export error1.png

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).

Solution :

Choose “Export to Excel”. You should be able to export.

Ledger export error2.png

By: Aimi 210716, Lay Swan 210726, P210727

Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1

IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS

Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations