Bubble, there is a workaround option you can use if you are stuck with an older version of Excel, for example, Excel 5.0 (which has a limit of 16,384 lines per sheet), and you have either Win 3.1 or Win 95. Insert a calculated field based on the record number for each record. Then, filter your export so that the amount of records exported at any one time is less than 16,384. Many times, I used to have to export year-long reports that had (for example) four parts - - Jan-Mar, Apr-Jun, Jul-Sep, and Oct-Dec, each with around 12,000 records.
The good news is that the filter could easily be reset for each successive export. The bad news is that the exports often had to be either different tabs/pages within the Excel file, or, had to be different Excel files altogether, and linked together. This is where MS Access came in as invaluable, since it always handles larger files and exports.
Sincerely wish you luck, but keep this option as a "just in case."
We have users here that still are on version 4.05. Here's how they work around the 16,384 row export limit. When exporting your table, specify the file type for your output as a dBase (.dbf) file. With this file type, Monarch will export an unlimited number of rows. Obviously it'll still need to fewer than Excel 8.0's limit of 65,536 rows. But then you can open the .dbf file in Excel and it works fine, you just have to change the column formats.