QuickBooks reports are slow when exporting to Excel worksheet

QuickBooks reports are slow when exporting to Excel worksheet

Problem

When exporting a QuickBooks report to Excel, the export process is very slow.

Resolution

While in QuickBooks, perform the following:
  1. Open your QuickBooks company file
  2. Run a report to export to Excel
  3. Select Excel > Create New Worksheet
  4. Click Advanced in the "Send Report to Excel" window.
  5. Deselect the Freeze panes checkbox
  6. Click OK
  7. Click Export
The export process should now be much faster.
See it in action below: 


    • Related Articles

    • How to improve the performance of your QuickBooks company file

      Summary: Like every database-driven software, maintenance is required on a regular basis to keep your database (or in the case of QuickBooks, your Company File) healthy. This article will walk you through a few tips that will help you keep your file ...

    • Strikethroughs on PDF after exporting from Excel

      Problem When you using Sage Business Intelligence and using the Excel Add-In, the data content looks correct, and displays properly. However, when the data is exported as a PDF, all the formula cells display as strikethroughs Reason When exported to ...

    • Setting up Scheduled Reports in Quickbooks v17 and newer

      Intuit has introduced "Scheduled Reports" in Quickbooks Enterprise v17 and newer.  Unfortunately, this is not a feature that will work in a hosted environment, per Intuit.  ...

    • I receive a "Not enough memory" error when exporting to Excel

      Problem: When attempting to export a report from Quickbooks to Excel, you may receive the following error message When clicking ok, you only have the option to export to CSV, like the screenshot below:  Reason: This error usually pops up if the ...

    • QuickBooks Desktop Statement Writer Error

      Description When you are trying to open an existing QuickBooks Desktop Statement you get an error "Microsoft Office Document Customization" as or you do not see the "Document Actions" section in hosted MS - Excel    OR Why is this issue happening It ...