Currently when exporting transactions to excel the limit is 65536 rows, but allowing user the option to use the Excel 2007 format would increase this to 1048576 rows. As a work-around we can download to CSV, but this file is formatted poorly when compared to the Excel export.