Learn how to fix an issue where the Export option for Excel is grayed out in QuickBooks Desktop.
When the export option for Excel is grayed out in QuickBooks Desktop (and the only option available is to export to a comma separated values (.csv) file), it is due to the following reasons:
Excel is not installed on your computer.
Excel is installed across a network.
The local Excel installation is damaged.
Make sure you have an active and up-to-date version of QuickBooks. If your version of QuickBooks is up-to-date (and you still can't export to Excel), try to Repair QuickBooks.
You might be able to resolve this issue by installing a compatible version of Microsoft Office on your computer or by running Detect and Repair for Microsoft Office. If Detect and Repair doesn't work, try uninstalling and reinstalling MS Excel.
Microsoft Office needs to be installed prior to QuickBooks installation because it is during QuickBooks installation that the connection happens with Microsoft Office/MS Excel. For help, go to Microsoft site.
For information and instructions, visit the Microsoft Support website or search our support site for QuickBooks System Requirements to see the list of compatible versions of MS Office for your version of QuickBooks.
Toggle the User Account Control (UAC) in Windows
To troubleshoot the issue you will need to toggle the UAC in Windows.
Turn off UAC. Windows 7, 8, and 10
Select the Windows Start button.
Go to User Account Control Settings.
Type Change User Account Control Settings and press Enter; or
Type Control Panel and press Enter. Select User Accounts, then Change User Account Control Settings.
Move the slider to Never Notify. And choose OK.
Select the Windows Start button. Then select Control Panel.
If it is not already selected, choose Classic View.
Double-click User Accounts.
Choose Turn User Account Control on or off.
Select or clear Use User Account Control (UAC) to help protect your compute. Then choose OK.
Restart your computer.
Restart QuickBooks. And open a Company file.
Go to Reports. And select a report.
In the report, select the Export button. All export options, including Excel, should now be available.
If none of these solutions fix the issue, please reach out to a qualified IT professional for further help.