Connected to SQL Server 2012 on Toad Data Point 3.3 to perform an export template using a Stored Procedure to generate a dataset and save it to an Excel (.xlsx) file. The results is almost 22,000 rows; however the resulting Excel file only writes 1,465 records.
Viewing the event log it's writing the data in blocks of 5,000:
But it seems to overwrite each sequence before and only write down to the Excel file the last block which equates to 1465 rows.
In the Export Wizard, increased the read buffer size to 40K read\write all rows in one block.