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:
Important: Be sure to have your Office installation disk(s) and key code available before you follow the steps shown below.