Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
N
ncgross
July 16, 2020
Question

Error 2147221164 when trying to run a tax form worksheet in excel

  • July 16, 2020
  • 50 replies
  • 132 views

I keep receiving error code 2147221164 Class not registered when trying to run a tax form worksheet in Excel.  We use a manual payroll and the report ran correctly in April 2020.  I called the Desktop help and they told me it was a Payroll issue and the payroll people told me they could not help me since we do not have a payroll subscription. 

Any ideas how to fix the issue

50 replies

R
Rasa-LilaMQuickBooks Team
QuickBooks Team
July 16, 2020

Thanks for reaching out to the Community about your concern, ncgross.

 

It’s my priority that you can export the tax form worksheets seamlessly. We’ll be performing some troubleshooting steps to fix this, which includes the following:

 

To begin, download the latest QuickBooks release. This can help improve the overall performance of the software and fix known issues.


Here’s how:

 

  1. Go to the Help menu at the top to choose Update QuickBooks Desktop.
  2. Tap the Update Now tab to mark the box for Reset Update.
  3. Click on the Get Updates button to remove the previously downloaded releases.
  4. Hit OK to continue.
  5. Once completed, close and reopen your QuickBooks to kick off the installation.

Next, try opening the tax form worksheet and export it. If you continue to get the same result, make sure your computer meets the program’s system requirements.


This will ensure the application is compatible with your setup and will help avoid unexpected behavior when using it. The following links provide detailed information about the system requirements for each QuickBooks version.

 

However, if your version is compatible, repair Excel to fix the issue. The Repair an Office application link contains detailed instructions about the process. If none of these suggestions work, perform Steps 4-5 in the Repair an Office application article.

 

You can bookmark the Excel-based payroll reports article for future reference. It contains instructions on how to build the reports as well as information about each one. 


Let me know in the comment box if you need further assistance performing any of the troubleshooting steps. I’m here ready to help and make sure you’re taken care of. Have a good one.

N
ncgrossAuthor
July 17, 2020

Thank you for the suggestions.  I ran both the QuickBooks update and the Office reload.  I am still getting the same error.  Since you suggested both options, do you think this is an Quickbooks or Office issue?  I am running QB Desktop Pro 2019 and Microsoft 365 Apps for Business.  Any other suggestions?

 

Z
ZackE_Moderator
Moderator
July 17, 2020

Thanks for the screenshot, ncgross.
 

Since you've updated to our latest release and performed a repair of Microsoft Office, I'd recommend checking out the resource my colleague, Rasa-LilaM, provided about QuickBooks Desktop 2019 system requirements. This will help confirm what your computer needs to provide the best user experience. Additionally, the error message recommends trying to restart your device.
 

When exporting reports to Excel, you'll want to make sure they have less than 256 columns. If there's a greater amount, you can select Advanced and untick the Space between columns checkbox, then hit OK to save your changes.
 

I've checked our ongoing and solved investigations to see if Intuit's aware of an error message like this when exporting to Excel. Currently, there's no investigation record for it.

I notice you mentioned a repair was run for Office, but there's also some other procedures in that same Repair an Office application article provided by my colleague which go over how to toggle Windows user account controls (UAC) to reset anything that may be blocking the feature from working properly. There's also a recommendation in step 5 (after the repair is completed) to uninstall and reinstall QuickBooks. Definitely try these steps out and let me know how they work for you.
 

Here's a helpful resource about exporting reports to Excel: Export reports as Excel workbooks in QBDT
 

Please don't hesitate to respond in this thread if you have any other questions. The Community will be here to help. Have a great weekend!

P
pmcgv
January 7, 2021

I ran into this problem today after migrating to a new Windows machine. I called Quickbooks Support and spoke with multiple people, each who tried to sell me a support subscription, but none of whom could  guarantee the problem could be resolved even if I purchased support or upgraded QB (I'm still using Premier 2018.)

 

I tried some of the suggestions listed here and some of their suggestions, and none worked. After 4 phone calls, multiple emails and 2 hours of no-help support, I finally insisted that they contact whoever was working on the issue, since it's here on their discussion group and has obviously been identified as a problem. She begrudgingly did, and 30 seconds later she told me to uninstall my 64-bit version of Office 365 and reinstall the 32-bit version. That did the trick.

 

To do that:

1) Uninstall your current version of Office 365

2) Log into your Office.com account

3) Click the "Install Office" Link (currently at top right of page)

4) Select "Other Install Options" from the drop down that appears

5) Click on the "View apps and devices" button

6) From the resulting page, you can select Office, the language, and the version (32 or 64-bit.) Select the 32-bit version.

 

Hopefully this post will solve some headaches.

 

    K
    kristib
    January 15, 2021

    Thanks so much! Reinstalling Office 365 in 32-bit solved the problem for me, too. It must have to do with a compatibility issue with the 64-bit version and Quickbooks.

    K
    kbon
    July 3, 2021

    uninstall your excel 64 bit and reinstall 32 bit--this will allow you to run tax form worksheet in excel.  Took me many hours to figure this out. But it finally!

    N
    NMP700
    March 9, 2023

    Hello:

    I have been having this issue for over a year. I have spoken to multiple QB reps via phone and chat, but they have not been able to resolve the issue. I have seen this issue posted on several different forums as well. like the others, I am getting an error message whenever I try to export payroll related items to excel. I just need the data to complete my reports. The error only happens when I try to export tax related items to excel. I can export all other reports with no issue. I have taken all the steps that were provided by the various reps, as well as everything listed in this forum. Including changing to 32-bit of Excel. Still nothing works. Is it possible to request a supervisor visit this chat since it is such a persistent issue?

    Please assist.

    T
    TobyTyler
    January 16, 2026

    Last October 2025, after moving QuickBooks Desktop Pro 2021 from a Windows 10 laptop to a new Windows 11 laptop, I lost the ability to create tax form worksheets in excel.  Today, I stumbled across the fix.  I discovered that several template files were missing from the "C:\Program Files (x86)\Intuit\QuickBooks 2021\Components\Templates folder."  After copying all the template files on my old laptop to the new laptop inside this folder, the tax form worksheets in excel were restored.  Here is the list of files.

    QB_Cert_Pay.xlt
    QB_DD_Rpt.xlt
    QB_Department.xlt
    QB_DF_Comp.xlt
    QB_Liab_Balances.xlt
    QB_LocalTax.xlt
    QB_Payroll_Link.xlt
    QB_Payroll_Rpt.xlt
    QB_Taxforms.xlt
    QB_Taxform_Link.xlt
    QB_TaxTrack_Rpt.xlt
    QB_TimeOff_Report.xlt
    QB_Time_Reports.xlt
    State_SUI.xlt
    State_W2.xlt
    template.cfg
    template401k.cfg
    templateEmployeeForms.cfg
    templateSUI.cfg
    templateW2.cfg
    templatexml.cfg

    Hopefully, others will find this solution.

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement