#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.

Functions with Excel 4.0 (XLM) macros can't be evaluated for one or more of the following reasons:

  • Excel 4.0 (XLM) macros are turned off because of macro settings.

  • Excel 4.0 (XLM) macros aren't supported in current version of Excel.

For more information, see Working with Excel 4.0 macros.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Office Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×