This article sets out steps to follow when you get a scheduled report with a macro to execute


How to know if my report has macro

Your report has a macro if the file type is .xlsm (Microsoft Macro-Enabled Worksheet)


How to get results 

  • Save the file on a local folder (or network drive)
  • Open the file and click on Enable Editing:  
  • Then click on
  • Click on the button in the file looking like this:
  • The macro will then execute and display results.
  • Save the file again to save the results.