Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
Fix the #BLOCKED! error
Excel onlyWhat #BLOCKED! means
#BLOCKED! appears in Excel when a Linked Data Type field or an external data request is blocked — usually because the workbook's privacy level prevents it from sending data externally, or because an administrator policy restricts the feature. It is a permission error, not a formula syntax error.
Common causes
- The workbook's privacy level is set to 'Private' and Excel blocks external data calls to protect potentially sensitive cell content from being sent to Microsoft servers.
- An IT or Microsoft 365 administrator policy has disabled Linked Data Types or external data for the organization.
- The cell content that would be sent as the lookup query contains data classified as sensitive under the current privacy settings.
- The user is not signed in to a Microsoft account with a qualifying Microsoft 365 subscription.
- The workbook is saved in a format (e.g., .xls) that does not support Linked Data Types and the feature is therefore blocked.
Example fix
Broken
=A2.PriceFixed
=IFERROR(A2.Price,"Blocked — check privacy settings")IFERROR surfaces a readable message while you resolve the underlying privacy or permission issue; remove it once #BLOCKED! is resolved.
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How to fix it
- 1Go to File > Options > Trust Center > Trust Center Settings > Privacy Options and review the 'Enable connected experiences' setting.
- 2Change the workbook privacy level: File > Info > Check for Issues > Inspect Document — or ask your IT admin to review the policy.
- 3Sign in to Excel with a Microsoft 365 account that includes connected services (Home, Business, or Enterprise tier).
- 4Save the workbook as .xlsx format. Linked Data Types are not available in .xls (Excel 97–2003) format.
- 5If the data is only for display, copy the cell value (Ctrl+C > Paste Special > Values) to replace the linked type with a static value.
Stop hunting errors by hand.
Upload your spreadsheet and the Auditor flags every #BLOCKED! and broken formula at once — or paste this one formula and get the fix explained.
Frequently asked
Why does #BLOCKED! appear only for some cells in the same workbook?
The blocked cells likely contain values that match a privacy trigger (e.g., names, IDs) while other cells contain generic text. Review which values are flagged and consider whether they need to be sent externally.
Can I permanently disable the #BLOCKED! restriction?
Individual users can enable connected experiences in Trust Center settings. However, if the restriction is set by an administrator policy (MDM/Group Policy), only IT can change it.
Is #BLOCKED! the same as #FIELD!?
#FIELD! means the field name is wrong or the data type did not resolve. #BLOCKED! means the request was deliberately prevented by a privacy or permissions setting. The causes and fixes are different.