A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Yes. If the Unblock checkbox is not present, use one of these supported approaches for a file that is trusted:
- Make the file a trusted document
- Open the workbook in Excel.
- If a yellow Security Warning bar appears, select Enable Content.
- In the Security Warning dialog, select Yes to make the document trusted.
- This enables macros for that document.
- Add the folder as a Trusted Location
- In Excel, go to File > Options > Trust Center > Trust Center Settings.
- Select Trusted Locations.
- Add the folder that contains the workbook.
- If trusted locations are disabled, clear Disable all Trusted Locations.
- Reopen the workbook.
- If the file is on OneDrive or SharePoint
- Open it by using Open in Desktop App.
- If it was downloaded locally before opening, remove the Mark of the Web from the local copy using an individual-file unblock method when available.
- Another supported option is to designate the location as a Trusted site.
- If the file is on a network share
- Add the location to Trusted Locations.
- If needed, allow documents on the network to be trusted in Trust Center settings.
- Microsoft also documents adding the location to the Local intranet zone or designating it as a Trusted site.
- Check macro settings if the file still cannot be trusted
- Go to File > Options > Trust Center > Trust Center Settings > Macro Settings.
- Use Disable all macros with notification if the goal is to get the Enable Content prompt.
- If a stricter policy such as Disable all macros without notification is applied, the file might not be able to become a trusted document.
Important: Trusting a location allows macros in all files stored there to run. Only use this for folders and files from trusted sources.
- Macros from the internet are blocked by default in Office
- Enable or disable macros in Microsoft 365 files | Microsoft Support
- Trusted documents | Microsoft Support
- Blocked Macros - Microsoft Q&A
- Unblock macros that Microsoft has blocked because source of the file is untrusted - Microsoft Q&A
- Macros from the internet are blocked by default in Office