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

Revision as of 08:38, 27 July 2021 by LaySwan (talk | contribs) (Created page with "'''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 nu...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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

  AutoCount Accounting 2.0


  AutoCount Accounting 1.8 / 1.9
  AutoCount Payroll
  AutoCount POS


  AutoCount On The Go
  AutoCount Accounting Plug-In Documentations