Export to Excel Issues in QuickBooks
                     Export to Excel Issues in 
QuickBooks
When you export reports to Excel, (both for new and 
existing worksheets) QuickBooks crashes or freezes with 
no progress. A damaged or outdated MS Excel can be one 
of the apparent reasons for this error to occur. When the 
error occurs, you may not be able to proceed with an 
ongoing task. Now let's look at the solution for 
Export to Excel Issues in QuickBooks Issue.
Causes Behind This Issue
• MS Office and QuickBooks versions are not 
compatible
• MS Office or QuickBooks installations are 
damaged
• There is a problem with the report or the data file 
itself
• The file registry may not be working properly.
Follow the steps below for troubleshooting
• After pressing the Export to Excel button in QuickBooks, you 
will see the window
• Click the Advanced button.
• Uncheck the box labeled Freeze panes. Press OK.
• Press Export.  The data should now export without freezing.
• Once the export is complete, if you need to view the resulting 
spreadsheet with the panes frozen, you can re-enable it by 
highlighting the appropriate cells.
• Then, click the View tab and click Freeze Panes as shown 
below.
For more detailed solutions you can visit 
DancingNumbers.com where you can find all the related 
links, topics, and video tutorials that would help you 
with all the topics related to exporting data. It also 
provides you with the required information and added 
knowledge about the software.
Source: 
Dancing Numbers