Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

Microsoft Excel error: The data returned from QuickBooks has nn,nnn transaction detail lines

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.

Why is this happening

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.

What you can try now

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.

  1. From the Reports menu, select Employees and Payroll > Client-Ready Reports.
  2. You may get a security warning if you do select Enable Macros.
  3. On the Client-Ready Payroll Reports window choose a shorter date range for the report.
  4. It may also help to choose only one report to run at a time.
  5. Click on Create Reports.




KB ID# INF12937
10/25/2016 10:23:34 AM
QYPPRDQBKSWS05 9138 Pro 2017 0853c8