Skip to main content

Hi, We have come across an issue where if we ‘order’ the business reporter report in Excel it errors as it cant find/run the macro. 

 

But if we ‘load’ report, it loads up with the box at the top to enable macros. We click enable, then ‘run’ and the report works fine. 

 

We have always had issues with these reports running out of the IFS application, which is why we use IFS Business Reporter instead.

 

Are you able to assist with this query please? 

Our company does have a policy where they don’t want users to use macros, but I’m not sure of another way around it so I’m looking for any options. 

thank you for your time!

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

Reply


Terms & ConditionsCookie settings