QuickBooks Export to Excel Not Working: A Quick Troubleshooting Guide

Known for its versatility, QuickBooks has now become the world’s leading accounting and financing software used by millions of companies and solopreneurs in managing their day-to-day business transactions. A product of Intuit, QuickBooks has several features and tools that help invoicing customers, paying bills, generating financial reports, filing taxes, payroll, and many more.

However, despite the impeccable features that are highly advantageous to all users, there is nothing is wrong saying in that using QuickBooks is not entirely free from errors and issues. Many companies prefer to format their reports and documents in Excel as it makes the data visualizations with charts and calculations much easy. However, users often face QuickBooks export to excel not working issue when they try to export reports and other forms to excel from QuickBooks Desktop. Usually, such an issue happens when the Microsoft Office program files get damaged or corrupted. With this post, we aim to provide all the necessary information that will help you in tackling QuickBooks won’t export to excel issue.

Looking for troubleshooting assistance resolving QuickBooks export to excel not working issue? If yes, feel free to reach our QuickBooks support team at (844-888-4666) and get assisted immediately.

What causes QuickBooks won’t export to excel issue?

Apart from damaged Microsoft Office program files, there are a number of other reasons also that can cause QuickBooks won’t export to excel issue, such as:

• The QuickBooks Desktop version you are using has been outdated.
• There is some damage done to QuickBooks program files.
• Windows User Account Controls (UAC) might be blocking the export feature of QuickBooks Desktop.

What should you do to resolve the QuickBooks export to excel not working issue?

Solution 1) Repair the Microsoft Office program for Windows

• On the keyboard, press Windows + R keys together to open the Run command window.
• Type “Control Panel” in the Run dialog box and then press the Enter key.
• In the control panel, search the Programs and Features option and select it.
• From the list of programs, select Microsoft Office and then click on the Change option.
• Select the Repair option and then hit the Continue button.
• Once MS Office repairing is completed, hit the Finish button.

Solution 2) Manually update the QuickBooks Desktop program to the latest release

• Press the Windows key to open the Start menu, type “QuickBooks Desktop” into the search box.
• Right-click QuickBooks Desktop and then choose the Run as administrator option.
• If prompted, enter the Windows administrator password.
• On the keyboard, press Windows + E keys simultaneously to open the File Explorer.
• Open the folder that contains company files using the following path: C:\Users\Public\Public Documents\Intuit\QuickBooks\Company Files.
• In the folder, look for the .qbw file and right-click it.
• Press & hold the Alt key on the keyboard and then choose the Open option.
• On the No Company Open window, go to the Help menu and choose the Update QuickBooks Desktop option.
• Select the Options tab and then click on the Mark All option.
• Go to the Update Now tab, checkmark the Reset Update checkbox, and then hit the Get Updates button.
• Press Alt + F4 keys together to exit out the No Company Open window.
• Open QuickBooks Desktop and then select the Yes option on the Installer update pop-up.

Solution 3) Get QuickBooks Desktop repaired for Windows

• On the keyboard, press Windows + R keys together to open the Run command window.
• In the Run command dialog box, type “appwiz.cpl” and then click on the OK button.
• From the list of programs, select the QuickBooks Desktop version you want to get repaired.
• Click on the Repair option and then hit the Next button.
• Once QuickBooks Desktop repairing is done, hit the Finish button.
• Restart the computer.

Solution 4) Turn off Windows User Account Controls (UAC)

• Open the Windows Start menu, type “UAC” into the search box, and select Change Windows User Account Controls settings.
• Select the slider and move it down to Never Notify.
• Hit the OK button.
• At last, restart the computer.

Solution 5) Reinstall QuickBooks Desktop on the computer

Step 1) Uninstall QuickBooks Desktop from the computer

• On the keyboard, press Windows + R keys together to open the Run command window.
• In the Run dialog box, type “appwiz.cpl” and then press the Enter key.
• From the list of programs, select QuickBooks Desktop and then click on the Uninstall option.
• Hit the Next button.

Solution 2) Manually rename the folder containing QuickBooks company files

• Select the Windows Start menu, type “File Explorer” into the search box, and then open File Explorer.
• Access the folder containing company files by navigating to the following path: C:\Users\Public\Public Documents\Intuit
• In the folder, look for the QuickBooks folder and right-click it.
• Choose the Rename option and then add the word “old” at the end of the folder’s name.

Now, you need to download the QuickBooks installation file from Intuit’s official website and install it. Thereafter, re-register QuickBooks Desktop using the license and product information

Conclusion:

If QuickBooks export to excel not working issue persists even after following all the troubleshooting solutions mentioned in the post, then there might be some compatibility issues between MS Office and QuickBooks Desktop versions. Our recommendation for you is to make sure that the MS Office version you are using is meeting the requirement of QuickBooks Desktop. You can also reach our QuickBooks professionals at (844-888-4666) and get over the issue immediately.