#BLOCKED errors are returned when a required resource can’t be accessed. See below for specific cases.
General
We couldn’t evaluate this function because you don’t have the required license.
You need to sign in to access this information.
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:
-
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 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.
Blocking
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.
Linked Data Types can't resolve because they are blocked by a Trust Center setting.
To unblock them, 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 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).
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.
IMAGE function
The URL of the source argument must use the https protocol.
The maximum size of the image specified in the source argument is exceeded.
The maximum size of the file is exceeded.
The image specified in the source argument can't be accessed with current security settings. For more information, see View my privacy options in the Microsoft Office Trust Center.
Need more help?
You can always ask an expert in the Excel Tech Community or get support in Communities.
