#BLOCKED!

%3CLINGO-SUB%20id%3D%22lingo-sub-3499776%22%20slang%3D%22en-US%22%3E%23BLOCKED!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3499776%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20used%20function%20%E2%80%9C%3CSTRONG%3E%3Dstockhistory%3C%2FSTRONG%3E%E2%80%9D%20I%20received%20back%20the%20cell%20with%20%E2%80%9C%23BLOCKED!%E2%80%9D.%3C%2FP%3E%3CP%3EHow%20can%20I%20solve%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3499776%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

When I used function “=stockhistory” I received back the cell with “#BLOCKED!”.

How can I solve it?

1 Reply

@francesco385 

first please,

Install Office updates.

after that...

Check privacy settings

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.

 

NikolinoDE

I know I don't know anything (Socrates)