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 ...
    • 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 ...
    • ADVISORY: Microsoft Update Causes Excel Export Error on MISys

      UPDATE: October 17, 2017 Microsoft has identified this as an issue with a recent Windows update, and are working to resolve it, For more information, you can view this article from Microsoft. They will provide an update in an upcoming release to ...