When you run a report and click to export it to Microsoft Excel, the only available option is to a CSV file. The other options are grayed out.
When trying to export to Excel, you might also see: Unrecoverable Error 14900 31866
QuickBooks does not recognize that Microsoft Excel is installed. QuickBooks finds Microsoft Excel by reading registry entries. If it cannot find Microsoft Excel then:
Important: Click to Run versions, Trial versions, and Starter Edition of Microsoft Office or Excel do not support the integration components used by QuickBooks (Click to Run Office is an online enabled, but limited edition of Office). If you are using one of these versions, the option to export to Excel is grayed out and unavailable. Please see the Microsoft Office 2010 FAQ for more information.
One or more of the following may resolve your issue:
If this solution does not resolve the issue, please review other available QuickBooks support options for additional guidance. You can also read and post messages relating to your issue on the QuickBooks Community forums.