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
April 26, 2022
Question

Tax forms in Quickbooks payroll report being block by macros

  • April 26, 2022
  • 11 replies
  • 149 views

When I select Reports, then Employee and Payroll, then More Payroll report in Excel, Tax Forms Worksheets, I received a security message regarding Macros have been disabled.  I have followed the instructions for the excel product I have, and still the message does not allow for information to show in report.  I am using Quickbooks desktop pro plus 2022.  Please assist with advise on how I can get this report to work in Excel?  this used to work in my previous Quickbook version 2019.

11 replies

Level 6
April 26, 2022

Thanks for checking in with us, @Genesis804.

 

I want to make sure you'll be able to export everything into Excel. Let's get you back up and running.

 

You can avoid this message by trusting the digital signature the workbook template is signed with.

 

Here's how:

  1. Hover over the words "Macros have been disabled" and they'll change to look like a hyperlink. 
  2. Click the link, then tap Enable Content.
  3. Select Advanced Options, then Trust all documents from this publisher, and finally, click OK.

 

You may also check these articles about exporting to Excel in QuickBooks Desktop:

 

 

I'm still here if anything may arise while exporting to Excel via QuickBooks Desktop.

April 27, 2022

This solution provided may be helpful to others, but did not work for me.  However, I did find another solution which did work as follows:

In Excel program, go to File

>Options

>Trust Center

>Trust Center Settings

>Trusted Locations

>Add New Location (which is toward bottom of screen)

Enter C:\Quickbooks 2022\Components\Templates

When I went back to Quickbooks Desktop Pro Plus 2022 program and clicked on Reports, then Employees and Payroll, then More Payroll Reports in Excel--it opens and imports the requested information.

Hope this is helpful to other users.  It worked for me!

February 17, 2023

This is the proper path for the trusted location in Excel for Quickbooks Desktop 2022:

C:\Program Files\Intuit\QuickBooks 2022\Components\Templates\

 

February 18, 2023

Intuit, WHY has this bug not been fixed in QuickBooks 2022 Release 7(R7) ???

This bug was reported here nearly a year ago, and is still not fixed.  Ridiculous.

 

JenoP
QuickBooks Team
July 19, 2023

Let's work together to ensure that you can successfully open the exported report in Excel., Nana0307.

 

Macros is a feature or add-on integrated into Microsoft Excel. Enabling this feature depends on your Windows settings or the location where the file is saved.

 

For example, the ability to turn it on might be restricted because the file is opened in an unsafe location such as the Temp Folder. It also happens if the system administrator has set the security policy in your organization to disable all macros without notification.

 

Although, you can try the other way of enabling macros for a specific workbook. Here's how:

 

  1. Go to the File tab, and then click Info in the left menu.
  2. In the Security Warning area, click Enable Content, and then choose Enable All Content.

 

In addition, you can carry out the following troubleshooting steps to explore more options:

 

 

Let me share this article for more details about the steps that I shared: Fix Export to Excel Issues in QuickBooks Desktop.

 

If you're still unable to locate the option to enable Macros, I advise reaching out to Microsoft's support team or visiting their website for further assistance.

 

For further guidance and information on running payroll reports, feel free to refer to these additional articles:

 

 

If you require further assistance with QuickBooks, we are readily available to help.