Fix export to Excel issues in QuickBooks Desktop
by Intuit• Updated 8 months ago
Learn what to do if the export to Excel option is greyed out or you can't select it.
If you have Microsoft Excel installed on your computer but you can't export reports and other forms from QuickBooks, don't worry. A few updates should fix the issue.
In this article, you'll learn how to:
- Update QuickBooks Desktop
- Check QuickBooks system requirements
- Repair Microsoft Office
- Toggle Windows User Account Controls (UAC)
- Reinstall QuickBooks
Note: If you’re using Microsoft Office 365, use the version installed on your computer. Don’t use the web browser version.
Step 1: Update QuickBooks Desktop
Make sure your version of QuickBooks is up-to-date. After you update, open QuickBooks and export a report:
- Go to the Reports menu and open any report on the list.
- Select the Excel button. All export options, including Excel, should be available.
If you still can't export, move on to Step 2.
Step 2: Check QuickBooks system requirements
Each version of QuickBooks Desktop works with specific versions of Microsoft Office. Check the system requirements for your version of QuickBooks: 2021, 2022, 2023.
If your version of Microsoft Office isn't compatible, you'll need to upgrade.
If your version is compatible, move on to Step 3.
Step 3: Repair Microsoft Office
Follow the steps from Microsoft to repair Microsoft Office.
Then go back into QuickBooks and export a report. If you still can't, move on to Step 4.
Step 4: Toggle Windows User Account Controls (UAC)
Toggle your Windows UAC settings on and off. This should reset anything blocking the export feature.
Note: These steps work for Windows 7, 8, and 10.
- Open the Windows Start menu. Type User Account Control Settings into the search and open User Account Control Settings.
- Select and move the slider to Never Notify. Then select OK.
- Restart your computer.
Go back into QuickBooks and export a report. If you can export a report, everything is fixed. If you can't, move on to Step 5.
Step 5: Reinstall QuickBooks
Microsoft Office and Excel need to be installed on your computer before you install QuickBooks. If you didn't install Microsoft Office first, uninstall and reinstall QuickBooks Desktop.
When you're done, go back into QuickBooks and export a report. If you still can't, you may need to follow the steps from Microsoft to uninstall and reinstall Excel.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Export reports as Excel workbooks in QuickBooks Desktopby QuickBooks•1•Updated January 08, 2024
- Get reports for previous reconciliations in QuickBooks Desktopby QuickBooks•4•Updated 1 year ago
- QuickBooks Desktop crashes when exporting report to Excel worksheetby QuickBooks•Updated June 24, 2024
- Import/export CSV filesby QuickBooks•5•Updated July 01, 2024