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: