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

Solution :

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

By: Aimi 210716, Lay Swan 210726, P210727

Go to menu

AutoCount Accounting 2.0 & 2.1 AutoCount Accounting 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations