Auto Enabling Macros on Business Reporter reports

Hi ​@SPierpoint 

First, you can check whether there are any Macros in the report design. If there are any Macros then you can delete them

Check for Macros in the Report

• Open the report in Excel.

• Go to Developer tab (if enabled) → Click Macros (or press Alt + F8).

• If there are macros listed, the file contains macros. If the list is empty, there are no macros.

  (If you don’t see the Developer tab, enable it by going to File → Options → Customize Ribbon → Tick Developer and click OK.)

Secondly, check Macro Settings to see if macros are disabled or enabled.

Check Macro Security Settings

• Go to File → Options → Trust Center → Trust Center Settings.
• Click Macro Settings to see if macros are disabled or enabled.

If they are enabled, make sure to disable them. 

After doing the above changes republish the report and order the report to see if the issue persists or not

Thank You

Thank you for this. We do need the macros in the report and wouldn’t want to disable or remove them.