Stockhistory -- #Blocked!

[DazedNConfused4SoLong]

I have been trying to used the Stockhistory() function, but have been getting the #Blocked! response. It has never worked for me, so this isn't a sudden change.

• I am using a Mac with a valid Microsoft 365 subscription, properly logged in
• I've gone to Privacy and can see the "Turn on Optional Connected Experiences" is checked. There are no other check boxes available.
• I've checked to make sure Excel is an exception for the firewall and have tried turning the firewall off.
• I've tried following steps suggested by the various AI's all to no avail.

Can anyone suggest any other steps I can try to get #Un-Blocked?

Thanks in advance!

 

[MARK858]

In your Trust Center see if the option in the image is checked

 

[DazedNConfused4SoLong]

Hi Mark - Thanks for your advice! I am using a Mac, so my MS applications do not have a Trust Center. The only thing somewhat equivalent that I can find is Privacy under Preferences. Various AI's have suggested I click on options that I just don't see on my app. I only see one check box (see below).

Any ideas on anything else I can do on a mac?

 

[MARK858]

I'll see if there is a mac equivilent