As a follow on:

If you export the transactions to Excel using File | Export | Transactions you need to change the default file extension from .XLS to .XLSX if you want to export more than 65,535 rows. Works fine. GridView ExcelDirect works fine too.

Exporting from Crystal Reports will not change. It is not designed for this type of operation.