How to correct a #BLOCKED! error

#BLOCKED errors are returned when a required resource can’t be accessed. See below for specific cases.

We couldn’t evaluate this function because you don’t have the required license.

You need to sign in to access this information.

We couldn't evaluate this function because of an application or system setting.

External connections to other workbooks are not allowed.

Check the permission on the file, Select Enable Content on the trust bar, or check the security and privacy options in the Microsoft Office Trust Center

This data type is currently not supported in your region.

You're unable to view data types because of your current privacy settings.

To allow viewing, do the following:

  1. Open the Trust Center: Select File > Options > Trust Center > Trust Center Settings.

  2. Under Security settings for linked data types, do one of the following:

  • To have Excel prompt users to allow viewing of data types, select Prompt user about linked data types.

  • To have Excel always allow viewing of data types, select Enable all linked data types (not recommended).

Linked Data Types can't resolve because they are blocked by a Trust Center setting.

To unblock them, do the following:

  1. Open the Trust Center: Select File > Options > Trust Center > Trust Center Settings.

  2. Under Security settings for linked data types, do one of the following:

  • To have Excel prompt users to allow viewing of data types, select Prompt user about linked data types.

  • To have Excel always allow viewing of data types, select Enable all linked data types (not recommended).

This connected data type can't be retrieved or updated by this version of Excel.

Open the document in a desktop version of Excel (Windows or macOS), or in Excel for the web.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

A subscription to make the most of your time

Need more help?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×