Microsoft has added a security enhancement that blocks macros from running in Excel files downloaded from the internet.
Microsoft has added a security enhancement that blocks macros from running in Excel files downloaded from the internet. Your IT organization can configure this at the domain level — but if not, here are two workarounds.
Option 1: Add a Trusted Location (Recommended)
Open Excel and click File → Options.
Select Trust Center, then click Trust Center Settings.
Click Trusted Locations, then Add new location.
Click Browse and select the folder where you save SOLYS reports.
Click OK to confirm.
We recommend creating a dedicated SOLYS Reports folder in your Documents directory and saving all SOLYS reports there. This keeps things organized and ensures macros work automatically.
Option 2: Enable VBA Macros (Less Recommended)
Open Excel and click File → Options.
Select Trust Center, then click Trust Center Settings.
Click Macro Settings and select Enable VBA macros.
Click OK.
Enabling all VBA macros reduces your security protection. Option 1 is the safer choice.