#UNKNOWN!Excel error guide No upload

#UNKNOWN! in Excel — Linked data type unavailable

#UNKNOWN! means Excel could not resolve a linked data type or one of its fields. The entity may not be recognised, the service may be offline, or the field is not supported for that entity.

Reviewed 31 October 2026 Tested in Excel 365; fixes apply to 2021, 2024 and Mac where the feature exists

The short answer

#UNKNOWN! means Excel could not resolve a linked data type or one of its fields. The entity may not be recognised, the service may be offline, or the field is not supported for that entity.

What it looks like

A Stocks or Geography cell shows #UNKNOWN!
The entity name is ambiguous or misspelled
The error appears after a refresh or an Excel update

Why #UNKNOWN! happens

The entity is not recognised by the data provider.
The data type service is temporarily unavailable.
The field does not exist for that entity or country.
The workbook was created in a version that used a different data provider.

How to fix #UNKNOWN!

1
Re-select the correct entity
Use the data type picker to choose the exact company, place or stock. Ambiguous names can resolve to the wrong entity.
2
Refresh and retry
Refresh the data type after a short wait. If the service is down, the error usually clears when it returns.
3
Check field availability
Not every field exists for every entity or region. Use the field picker to see the fields that are actually available, then update the formula.

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.

Open the interactive Error Fixer Check a formula

Related functions

IFERROR XLOOKUP

Frequently asked questions

What does #UNKNOWN! mean in Excel?

#UNKNOWN! means Excel could not resolve a linked data type or one of its fields. The entity may not be recognised, the service may be offline, or the field is not supported for that entity.

How do I fix #UNKNOWN! in Excel?

Re-select the correct entity: Use the data type picker to choose the exact company, place or stock. Ambiguous names can resolve to the wrong entity. Refresh and retry: Refresh the data type after a short wait. If the service is down, the error usually clears when it returns.

Why does #UNKNOWN! appear only in some rows?

Usually because only some rows contain the trigger: The entity is not recognised by the data provider. The data type service is temporarily unavailable. The field does not exist for that entity or country.

How can I stop #UNKNOWN! from appearing again?

Fix the underlying reference or data type, then test the formula on a copy of the sheet before filling it down.

Related Excel error guides

All error codes →

#VALUE!Wrong value type#VALUE! means Excel expected a number, date or logical value but found text, an empty cell or a value from another data type. The fix is to convert the input, remove hidden characters, or guard the calculation with IFERROR.#REF!Broken cell reference#REF! means a formula points to a cell, row, column or sheet that no longer exists. It usually appears after deleting rows or columns, moving a sheet, or pasting a formula into a workbook that does not contain the referenced sheet.#N/ALookup value not found#N/A means a lookup or match function could not find the value. The value may be missing, spelled differently, stored as text instead of a number, or surrounded by spaces. Use exact-match mode and return a clear fallback.#DIV/0!Division by zero#DIV/0! appears when a formula divides by zero or by an empty cell. Excel treats a blank denominator as zero. Check the denominator, exclude blank rows, or return a controlled blank with IFERROR.

Still stuck?

Send the workbook and get the formula fixed

A human Excel expert can repair the formula, explain the cause and return a tested workbook — usually within 24 hours. Fixed quote before work starts, from $15/hr.

Get a fixed quote Ask on WhatsApp

What it looks like

Why #UNKNOWN! happens

How to fix #UNKNOWN!

Re-select the correct entity

Refresh and retry

Check field availability

Check it in your own workbook

Related functions

Frequently asked questions

Related Excel error guides

Send the workbook and get the formula fixed

What it looks like

Why #UNKNOWN! happens

How to fix #UNKNOWN!

Re-select the correct entity

Refresh and retry

Check field availability

Check it in your own workbook

Related functions

Frequently asked questions

Related Excel error guides

Send the workbook and get the formula fixed