This error occurs when the source table contains more rows than MS Excel is able to process.
How the issue manifests
When exporting to Excel, the following error is displayed:
Invalid row number (1048576) outside allowable range (0..1048575)
What the error means
Excel has a limit on the maximum number of rows in a single sheet: 1,048,576.
👉 The export is attempting to write more rows than Excel allows.
Cause
The source table contains more than 1,048,576 rows, which Excel is unable to process.
How to resolve the issue
Limit the amount of data:
use a filter (e.g. date range, status, document type)
export data in smaller batches
Alternatively:
use a different format (e.g. CSV) and process the data outside of Excel
Recommendations
for large volumes of data, avoid exporting "everything" — use filters instead
Excel is not suitable for working with millions of rows