How to fix hidden module: cp interview error while trying to create Certified Payroll Report in QuickBooks

Question

I'm trying to run Certified Payroll Reports in QuickBooks Enterprise Solutions 2024 and I keep getting this error message:

Microsoft Visual Basic for Applications

Compile error in hidden module: cpinterview. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application Click "Help" for information on how to correct this error.

Answer 1

Hi @CMonroe, 

Good day! Thank you for reaching out to Microsoft Q&A forum and sharing the detail. 

Based on the message error, I’ve outlined some steps below that may help resolve the issue. When you have a moment, please try them and let me know how it goes. If you encounter any errors or notice anything unusual during the process, feel free to update me and I’ll be happy to investigate further and support you through it. 

Step 1. Update QuickBooks and Microsoft Office  Install all available updates for QuickBooks. Then download the latest payroll tax table. Outdated payroll templates often conflict with Excel. Next, update Excel by going to File > Account > Update Options > Update Now. This ensures that both QuickBooks and Excel are on the latest build and are compatible with each other. 

Step 2. Disable Excel add-ins and COM add-ins  Open Excel, select File > Options > Add-ins. At the bottom, choose “COM Add-ins” in the Manage box, then click Go and uncheck everything. Do the same for “Excel Add-ins.” Close and restart Excel, then try the Certified Payroll Report again from QuickBooks. If the error disappears, one of the add-ins is conflicting with the QuickBooks macro. You can re-enable them one by one later to identify which add-in causes the issue.

Step 3. Repair Microsoft Office  Go to  Settings > Apps > Installed apps and locate Microsoft Office in the list. Choose Modify, then run a Quick Repair. If the issue continues, repeat the process and run an Online Repair. This can fix missing or damaged components in Excel that prevent the VBA code from compiling. 

Step 4. Review Excel macro settings  In Excel, go to File > Options > Trust Center > Trust Center Settings > Macro Settings. Set it to “Disable VBA macros with notification.” This way, when you open the Certified Payroll Report, Excel will prompt you to enable macros. If macros are blocked entirely, the QuickBooks module cannot run and the compile error will appear. 

Once I have your update, I will check further and provide the most suitable solution based on the results. I really appreciate your cooperation and patience while we work through this together. 

Note: Please understand that our initial response does not always resolve the issue immediately. However, with your help and more detailed information, we can work together to find a solution.  

I hope this information is helpful. Please follow these steps and let me know if it works for you. If not, we can work together to resolve this.  

Thank you for your patience and your understanding. If you have any questions, please feel free to reach out. I'm looking forward for your reply.  

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".  

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @CMonroe,  

It's wonderful news that your issue has been resolved. I truly appreciate your effort in finding a resolution. I believe that many users may encounter similar issue, and your case could serve as a valuable reference for them.     

Therefore, I would make a brief summary of this post so that other forum members could easily find useful information here:  

Issue Description: “Compile error in hidden module: cpinterview” when generating Certified Payroll Reports in QuickBooks Enterprise Solutions 2024 

Resolution:  

1. Disconnect the user from the server to prevent interference during profile reset. 
2. Locate the user’s profile folder under C:\Users\ and rename it (like from Cathy to Cathy.old) to preserve existing data. 
3. Open the Registry Editor (regedit) and navigate to:  HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList 
4. Identify and delete the Security Identifier (SID) associated with the user to remove the corrupted profile reference. 
5. Have the user reconnect to the server. Windows will automatically generate a new profile. 
6. Confirm that a new profile folder has been created under C:\Users. 
7. Launch QuickBooks and verify that the user can now generate Certified Payroll Reports without encountering the cpinterview error. 
8. Restore the user’s personal data by copying the contents of Desktop, Downloads, and Documents from the old profile folder (Cathy.old) to the new profile. 

This procedure addresses profile-level corruption that interferes with Visual Basic for Applications (VBA) components required by QuickBooks. 

As other users may search for similar issues in this forum, your post and solution will be a helpful reference. If you found this helpful, consider voting or marking it as a solution to make it easier for others to find.  

I truly appreciate your time and cooperation throughout the resolution of this matter. Thank you for being a valued customer and for contacting us on the Microsoft Q&A forum.  

If you need any other assistance, please don’t hesitate to reach out again and I would be happy to help you.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".  

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.