Microsoft Excel, O365, Tech Blog, Tech Random's, Tips and Tricks

Excel unable to enable Macros when running QuickBooks Report.

Our most recent edit shows you the folder to specifically trust: http://strongitguy.com/quickbooks-set-excel-to-open-with-macros-enabled-when-running-reports/

User goes to open up an Excel report from Quickbooks and receives a Security Warning that Macros have been enabled.

 

There are two ways to "Fix" this based on your security settings and environment. The first is the easiest for most users.

For this, we are going to add the folder that you use to save these reports to, to your trusted locations within the trust center in Excel.

Run the desired report -> Save as to your designated folder ->

Open Excel -> File -> Options -> Trust Center -> Trust center Settings -> Trusted Locations:

Then click -> Add new Location -> Navigate to the folder you save your reports to by clicking Browse ->then selecting the folder location. Make sure to choose the subfolder check box if you plan to save files in other folders inside the main.

Leave a Reply

Your email address will not be published. Required fields are marked *