When customer creates a client-ready payroll report in excel, the information is being transferred from QuickBooks to Excel and then a Microsoft Excel error appears:
The data returned from QuickBooks has nn,nnn transaction detail lines. This is too much data for this Excel workbook, which can hold up to 65,536 transaction line detail lines.
Excel 14 can hold up to 1 million rows of data, but only when the workbook is first saved in Excel's new file format.
This is a program limitation in QuickBooks.
When QuickBooks first creates the Microsoft Excel worksheet, it creates an .xls sheet, which is limited to 65,536 (2**16) rows. The error occurs once QuickBooks has gathered all of the data for the reports and sends it to Excel. If the number of detail transaction lines is greater than 65,536 the message appears and connectivity with QuickBooks is lost.
While it is true that Microsoft Excel 2007 and 2010 have larger limits that 65,536, those larger limits are not available in .xls spreadsheets.
Upgrading from Excel 2007 to Excel 2010 is not a fix for this issue at this time.
Workaround: Reduce the number of transactions in the report.