QuickBooks HelpQuickBooksHelpIntuit

QuickBooks Desktop crashes when exporting report to Excel worksheet

by Intuit Updated 4 months ago

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
Note:
  • 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.

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

QuickBooks Desktop Enterprise DiamondQuickBooks Desktop Enterprise Diamond 2021QuickBooks Desktop Enterprise GoldQuickBooks Desktop Enterprise Gold 2021QuickBooks Desktop Enterprise PlatinumQuickBooks Desktop Enterprise Platinum 2021QuickBooks Desktop Premier 2021QuickBooks Desktop Premier PlusQuickBooks Desktop Pro 2021QuickBooks Desktop Pro Plus

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this