Jun 13 2022 05:37 AM
When I used function “=stockhistory” I received back the cell with “#BLOCKED!”.
How can I solve it?
Jun 13 2022 06:51 AM
first please,
after that...
You cannot view data types due to your current privacy settings.
To enable viewing, do the following: Open the Trust Center:
Select File > Options > Trust Center > Trust Center Settings.
Under Security Settings for Linked Data Types, do one of the following:
a)To have Excel prompt users to allow data types to be displayed, select Prompt users about linked data types.
b)To allow Excel to always allow data types to be displayed, select Enable all linked data types (not recommended).
Linked data types are blocked Linked data types cannot be resolved because they are blocked by a Trust Center setting.
To unblock, do the following:
Open the Trust Center: Select File > Options > Trust Center > Trust Center Settings.
Under Security Settings for Linked Data Types, do one of the following:
To have Excel prompt users to allow data types to be displayed, select Prompt users about linked data types.
To allow Excel to always allow data types to be displayed, select Enable all linked data types (not recommended).
Hope I was able to help you with this info.
I know I don't know anything (Socrates)