Support Portal
            Knowledgebase gotomyerp Application Help Quickbooks

            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.

            Updated: 31 Oct 2018 06:40 PM
            Helpful?  
            Help us to make this article better
            0 0