How to unblock macros in excel

Question

I cant seem to unblock macros on my excel spread sheet .

I've tried the below options

Options 1

1. Tap the start button or Windows key and type Internet Options.
2. Select Internet Options from the search results and the Internet Properties dialog box will appear.
3. On the Securitytab, select Trusted Sites, then select Sites.
4. 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 Option 2
5. Open Windows File Explorer and go to the folder where you saved the file.
6. Right-click the file and choose Propertiesfrom the context menu.
7. At the bottom of the Generaltab, select the Unblockcheckbox and select OK.

Option 3

1. Click the File tab.
2. Click Options.
3. Click Trust Center, and then click Trust Center Settings.
4. In the Trust Center, click Macro Settings.

Answer 1

You may try

1. add your network drive as trusted location.

2. If the above step doesn't work, you should download the file and put that file to a local trusted location.