Step-by-Step Guide to Get Rid of QuickBooks Error 2147221164

Last Updated on April 13, 2026

QuickBooks error 2147221164 is a payroll error that occurs when you try to run a tax form worksheet in Excel. Consequently, you won’t be able to export reports to Excel from QuickBooks Desktop. When it comes to its causes, QuickBooks’ incompatibility with your computer plays a crucial role in triggering the issue. Secondly, when a Microsoft 365 application, such as Excel, doesn’t work correctly, QuickBooks error 2147221164 will likely halt payroll.

Many other reasons also significantly contribute to the occurrence of this payroll error. This troubleshooting blog is a solution to all your concerns. It contains some of the best practical solutions with step-by-step instructions to fix the error. Additionally, you will also gain valuable insights about the root causes.

Therefore, read this blog until the end and immediately get your payroll operations back on track.

What Leads to QuickBooks Error 2147221164?

A better understanding of these causes allows for a more focused approach. Multiple circumstances cause these errors. Let’s discover them one by one:

You have installed QuickBooks on the system before Microsoft Office and Excel
When MS Excel doesn’t work properly
When QuickBooks is not updated
When the computer is not compatible with the QB application

An issue with Microsoft components or UAC settings can also lead to compile errors in QuickBooks. Therefore, you need to resolve them timely.

For QB Pro, Premier 2023, or Enterprise 23.0

Note: QuickBooks 2023 doesn’t support Windows 8.1 and cannot be installed on it.

1. Operating Systems Required

• Windows 11, 64-bit, natively installed
• Windows 10, all 64-bit editions, natively installed
• Windows Server 2022, Standard and Essentials
• Windows Server 2019, Standard and Essentials
• Windows Server 2016, Standard and Essentials
• Windows Server 2012 R2, Standard and Essentials
• Windows Server 2012, Standard and Essentials

Note: It is important to know that QuickBooks requires you to use Windows natively and not through an emulator or virtual environment.

2. Database servers

• Windows (natively installed)
• Windows Server 2022, Standard and Essentials
• Windows Server 2019, Standard and Essentials
• Windows Server 2016, Standard and Essentials
• Windows Server 2012 R2, Standard and Essentials
• Windows Server 2012, Standard and Essentials

Note: It is essential to know that Linux and Windows 10 S modes are not supported.

3. Minimum Requirements for a Browser

QuickBooks uses your default browser.

4. Hardware and Operating System Requirements

Note: QuickBooks Desktop 2023 requires a 64-bit Windows operating system as it won’t run on 32-bit.

5. Other Software

Microsoft.NET 4.7 Runtime, 60 MB.

6. Other Hardware

Suggested tools for the Warehouse Manager of QuickBooks Desktop mobile.

7. Software compatibility

It integrates with Microsoft Office, TurboTax, Quicken, and other apps, each with specific compatibility requirements.

8. Compatibility between antivirus and antimalware software:

It may be required to adjust some settings in these programs for the best experience:

Antivirus software

• McAfee
• Avast
• Bitdefender
• Norton
• Kaspersky
• Trend Micro Security
• Webroot
• Cylance (Internet/Regression Only)
• ESET
• Panda Dome
• Sophos
• Avira
• Symantec
• F-Secure

Anti-malware software

• Bitdefender
• AVG
• Malwarebytes
• Spybot
• Emsisoft
• McAfee
• Avast
• Webroot
• ZoneAlarm
• Kaspersky
• F-Secure

Note: QuickBooks Desktop 2023 requires internet security protocol TLS 1.2 for the connected services to work seamlessly. If your version is compatible, you should move forward to implement the troubleshooting steps.

7 DIY Troubleshooting Methods to Overcome QuickBooks Error 2147221164

Now that we understand the necessary system specifications and the reasons behind QuickBooks error 2147221164, we can proceed with a detailed approach to resolving this error.

Method 1: Update QuickBooks to the Latest Release

As mentioned above, using an outdated version of QuickBooks is one of the reasons for the run-time error 2147221164. So, let’s update the QuickBooks to the most recent release by following the steps below:

• Open QuickBooks Desktop, go to the Help menu, and select Update QuickBooks Desktop from the drop-down box
• Select the Update Now tab in the Update QuickBooks Desktop Window
• Check the Reset Update checkbox to clear all previous update downloads
• Hit the Get Updates option and then hit OK to continue
• After downloading the update, QuickBooks will ask to restart the computer to install it
• Lastly, close and reopen QuickBooks to begin the installation

The next step is to check whether the issue has been resolved. Hence, open the tax form worksheet and export it. If you continue receiving the same error, check the following resolution.

Method 2: Repair Excel to Fix the Issue

When Microsoft applications such as Word or Excel don’t work properly, restart the application to fix the issue. However, if restarting doesn’t work, you need to repair them. Here’s how you can repair Excel for different operating systems.

For Windows 10:

• Right-click the Start button in the lower-left corner and choose Apps and Features on the pop-up menu
• Choose the Microsoft Office product you want to repair, and then choose Modify
• Depending on your office installation type, you’ll see the following options for the repair

Consider following the steps suitable for your installation type.

Click-to-run

In the How would you like to repair your Office programs Window, select Online Repair > Repair to ensure everything gets fixed. Moreover, the faster Quick Repair option is also available, but it only detects and then replaces corrupted files.

MSI-based

Select Repair in the Change your installation, and then click Continue.

For Windows 11:

• Right-click the Start button in the lower-left corner and choose Installed Apps on the pop-up menu
• Choose the Microsoft Office product you want to repair, click the ellipses, and choose Modify
• Depending on your office installation type, you’ll see the following options for the repair. Consider following the steps suitable for your installation type

Click-to-run

In the How would you like to repair your Office Programs Window, select Online Repair > Repair to ensure everything gets fixed. Moreover, the faster Quick Repair option is also available, but it only detects and then replaces corrupted files.

MSI-based

Select Repair in the Change your installation, and then click Continue

• Lastly, follow the instructions on the screen to complete the repair

Now, open the tax form worksheet and export it again. If the error persists, consider implementing the next solution

Method 3: Toggle Windows User Account Controls (UAC)

Toggle your Windows UAC settings on and off to reset anything blocking the export feature. Let’s learn how to toggle the Windows UAC by following the steps below:

Note: These steps apply to Windows 7, 8, and 10.

• Go to the Windows Start menu, type User Account Control Settings into the search bar, and click Open
• Select and move the slider to Never Notify, then hit OK
• Lastly, restart the system

Excel Class Not Registered

Fix the ‘Excel Class Not Registered’ error quickly with our troubleshooting tips. Ensure smooth operation of Excel for uninterrupted productivity.

Now, open QuickBooks and export a report. If you can successfully export, it simply means the payroll issue has been fixed. Unfortunately, if you still see the same error, switch to the next solution.

Method 4: Reinstall the QuickBooks Application

Microsoft Office and Excel must be installed on the system before you install QuickBooks. If you have already installed QuickBooks but haven’t installed Microsoft Office and Excel, consider uninstalling and then reinstalling QuickBooks. When you install QB Desktop again, it renames the QB folders to fix company file issues. Let’s learn how to install it again.

Note: When you reinstall QB, it doesn’t affect the company data at all.

Prerequisites before you begin:

• Consider downloading the installer for your version of QuickBooks
• Get ready with the license number, which will be required later. You can find it in the original package. In case you have bought it online, the purchase confirmation email contains the license number

Step 1: Remove QuickBooks

• Open the Windows Start menu, look for Control Panel, and then tap to open it
• Opt for Programs and Features or Uninstall a Program
• A list of programs appears; choose the version of QuickBooks you want to uninstall
• Choose Uninstall/Change, Remove, and then hit Next

If you don’t see this option, consider signing out and signing back in to Windows with admin rights.

Step 2: Install QuickBooks Desktop Again

The very first thing you need to do is download QuickBooks Desktop. Only after downloading QuickBooks can you install it. Let’s learn how to install it by following the simple steps:

Prepare for the Install

• Ensure the computer meets the system requirements
• Get ready with the license number

Install QuickBooks Desktop

• Launch the QuickBooks.exe file
• Follow the instructions on the screen, accept the software license agreement, and then hit Next
• Enter the product and license numbers, and then choose Next

Note: Installing QuickBooks on the system requires an active internet connection.

• Choose Express and then hit Next
• Choose Install
• Lastly, when the installation finishes, select Open QuickBooks

Note: After installation, QB will ask to activate and update it. Secondly, QuickBooks automatically installs new folders and renames the old ones when you reinstall it.

Now, export the tax form worksheet again to check whether the issue has been resolved. If this doesn’t fix QuickBooks error 2147221164, consider reinstalling QuickBooks manually in the next solution.

Method 5: Uninstall QuickBooks and Rename Installation Folders Manually

If you wish, you can uninstall QuickBooks and rename installation folders manually. Here’s how you can do it:

• Firstly, uninstall QB again
• Secondly, open the Windows Start menu, look for “File Explorer,” and then tap to open it
• Find and open the QuickBooks folder that holds the company file. This folder is usually found in one of these locations:
  • C:\ProgramData\Intuit\QuickBooks (year)
  • C:\Users(current user)\AppData\Local\Intuit\QuickBooks (year)
  • C:\Program Files\Intuit\QuickBooks (year)
  • 64-bit version C:\Program Files (x86)\Intuit\QuickBooks (year)
• Right-click the folder and choose Rename
• Consider including “old” at the end of the folder name. It prevents QuickBooks from opening this specific folder when you install the application again

Lastly, reinstall the QBDT following step 2 of solution 4, as discussed above.

Method 6: Running the QuickBooks File Doctor

A variety of tools are available in the QuickBooks Tool Hub to address common problems with the QuickBooks Desktop. QuickBooks File Doctor is one of the tools to help resolve issues related to the program. Learn how to run it:

Step 1: Get the QuickBooks Tool Hub

• Close QuickBooks. Then, download the latest version of the QuickBooks Tool Hub and save the file somewhere you can easily access it later

Note: If the Tool Hub is already installed on your system, consider checking its version. The Tool Hub version appears at the bottom when you select the Home tab.

• Launch the downloaded file (QuickBooksToolHub.exe). Then, follow the on-screen instructions to install the utility and agree to the terms and conditions
• Open the Tool Hub by double-clicking its icon when the installation finishes

Note: In case you can’t see the Tool Hub icon, search for it manually in the Windows search bar and then select the program

Step 2: Launch File Doctor

• Open the Tool Hub and then select Company File Issues

• Choose the Run QuickBooks File Doctor. The File Doctor may take up to one minute to open. However, if it doesn’t open, you must search for and open it manually
• Open QuickBooks Desktop File Doctor and choose the company file from the drop-down menu. If you can’t find the company file, click Browse and search to find it
• Tap Check your file and network, and hit Continue

The scan may take 10-15 minutes to finish, depending on the company file size. Secondly, the scan may notify that it was unsuccessful despite fixing the issue. Therefore, you need not worry if such a notification appears on the screen. Finally, open QuickBooks and the company file. In case the File Doctor doesn’t fix the issue, check out the next solution below.

Method 7: Manually Configuring QuickBooks Firewall Ports

If QuickBooks File Doctor doesn’t resolve the issue, let’s manually configure the firewall ports. Add firewall port exceptions for QuickBooks using these methods to ensure seamless working.

After that, check again whether the issue is resolved. These methods should help you resolve QuickBooks error 2147221164 by repairing damaged components and restoring the smooth functioning of the application.

A Quick Overview of Causes & Troubleshooting Methods to Fix QuickBooks Error 2147221164

The quick overview table below provides a condensed version of this blog on QuickBooks error 2147221164, including its main causes and effective troubleshooting methods.

Conclusion

Hopefully, the troubleshooting solutions in this blog have helped you get past the QuickBooks error 2147221164 effectively. However, if you are still struggling with the same error even after implementing these solutions, dial the QuickBooks Data Repair Service. Let our dedicated team assist you in resolving the payroll error 2147221164. Our professionals will offer a simple, straightforward resolution to your problem.

Frequently Asked Questions (FAQ’s)

Oriana Zabell

Oriana Zabell, a professional cloud engineer, has over three years of experience in desktop, online QuickBooks support and troubleshooting. She is currently working as a cloud hosting consultant with Asquare Cloud Hosting. She loves to read and write about the latest technologies such as cloud computing, AI, DaaS, small businesses, manufacturing. When not writing, she is either reading novels or is indulged in a debate with movie fanatics.