Following a recent change Microsoft has introduced new security measures to protect users against malicious Excel macros. Previously users may have seen the following message when opening RDTC Excel reports and by selecting Enable Content would allow users to use the spreadsheet with full functionality.
Following the recent change some users may receive the following message when opening our reports:
Many of our reports use macros to update when the viewing options are changed to select the appropriate ICB or sub-ICB. Stakeholders can address the security message by following the instructions by clicking on the Learn More option when the message appears. These options are summarised below, and a downloadable copy is available here.
Unblock all files from a specific network share or website
A preferable option is to set a network location or website as a trusted site in Windows so a macro from the site won’t be checked (this may require assistance from local IT services as Trusted sites may be blocked).
- Tap the start button or Windows key and type Internet Options.
- Select Internet Options from the search results and the Internet Properties dialog box will appear.
- On the Security tab, select Trusted Sites, then select Sites.
- Type the URL of the site or server that contains the Microsoft 365 files with the macros you want to run, and then select Add.
- Select Close and then OK.
Unblock a single file
- After downloading the file, open the Windows File Explorer and go to the folder where you saved the file.
- Right-click the file and choose Properties from the context menu.
- At the bottom of the General tab, select the Unblock checkbox and select OK.