Perform the following steps if QuickBooks is slow when exporting large files to Excel:

  1. Open QuickBooks.
  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 and verify that there is no latency when exporting the report.