#BLOCKED! in Excel — Linked data type blocked

What it looks like

• Stocks, Geography or another linked data type shows #BLOCKED!
• The same workbook works on another computer
• A privacy or consent prompt appeared earlier

Why #BLOCKED! happens

• The organisation has disabled linked data types.
• Privacy settings or consent for the data provider were declined.
• The Microsoft account or licence does not include the data type.
• A firewall or proxy is blocking the data service.

How to fix #BLOCKED!

1. 1

   Check privacy and consent settings

   Open File → Options → Trust Center → Trust Center Settings → Privacy Options and review the connected-experience settings. Your organisation may manage these centrally.

2. 2

   Try a different account or network

   If the workbook works elsewhere, the block is tied to the account, licence or network. Ask IT whether the data type service is allowed.

3. 3

   Use a manual lookup instead

   If linked data is blocked permanently, import a reference table and use XLOOKUP or VLOOKUP against it.

   =XLOOKUP(A2,$D$2:$D$500,$E$2:$E$500,"Not available")

Check it in your own workbook

Paste the formula into the free browser tools to see the exact fix without uploading your file. The Error Fixer explains the code, the Formula Checker finds syntax problems, and the Formula Explainer breaks down nested logic.

Related functions

Frequently asked questions