Showing results for 
Search instead for 
Did you mean: 
Get your Payroll questions answered by a QuickBooks Product Manager here -

QuickBooks Desktop crashes when exporting report to Excel worksheet

The solutions outlined in this article are generally not covered by CCP. If the customer doesn't have an active support plan, be sure to provide them with a solid roadmap and the best support option before you start troubleshooting. To learn more, refer to our software support policies (US or CA).

When you export reports to Excel, (both for new and existing worksheets) QuickBooks crashes or freezes with no progress. This is caused by any of the following reasons:

  • MS Office and QuickBooks versions are not compatible
  • MS Office or QuickBooks installations are damaged
  • There is a problem with the report or the data file itself
  • Limitation of earlier versions of MS Excel
Excel worksheet has 256 column limit and will result in a warning message- "Excel allows 256 columns in a worksheet", if exceeded.
  • How to export report from QuickBooks Desktop to Excel worksheet?

To troubleshoot the issue, you need to follow the outlined solutions in order.

Solution 1: Ensure the compatibility of QuickBooks Desktop and MS Office.

Review system requirements:

Solution 2: Update QuickBooks Desktop to the latest release.

Solution 3: Repair QuickBooks Desktop.

Solution 4: Verify and Rebuild Data in QuickBooks Desktop.

Solution 5: Repair MS Office.

Important: Intuit does not support Microsoft applications. We recommend having an IT professional to do this for you.

Was this helpful?

You must sign in to vote, reply, or post