← Back to Error Directory

How to Fix #FIELD! Error in Excel

A guide specific to Excel's Stocks, Geography, and other linked data types — what #FIELD! means and how to resolve it correctly.

Table of Contents

1. What #FIELD! Actually Means

#FIELD! is one of the more specialized error codes in Excel, tied exclusively to linked data types — the Stocks, Geography, and other "rich data" cell types that connect to Microsoft's cloud-based data sources. It appears when a formula asks for a specific field (like "Price" or "Population") from a linked data type card, but that exact field either doesn't exist, was misspelled, or isn't currently available from the data source.

This error is fundamentally different from most others on this site because it's not really about your formula's logic — it's about a mismatch between what you're asking for and what Microsoft's underlying data structure actually provides for that entity.

2. Understanding Linked Data Types

When you type a company name or ticker symbol and Excel recognizes it (converting it via Data → Stocks, or by typing text and selecting the Stocks data type from the ribbon), the cell no longer just contains text — it becomes linked to a rich data card containing dozens of fields: Price, Change, Volume, Market Cap, 52 Week High/Low, P/E Ratio, and more, depending on the entity type.

To pull one of those fields into another cell, you reference the linked cell followed by a period and the field name:

=A2.Price
=A2.Population
=A2."Market Cap"

Field names containing spaces must be wrapped in quotes as shown above. This dot-notation syntax is unique to linked data types — no other Excel feature works this way.

3. Interactive Demo: Field Name Lookup

Select a data type and see which field names are valid — try typing a field name with a typo to see #FIELD! trigger.

Try typing "Prices" (with an s) instead of "Price" to see #FIELD! trigger from a simple typo.

4. The Four Root Causes of #FIELD!

Cause 1: Misspelled or incorrectly capitalized field name

Field names must match exactly, though Excel is generally case-insensitive for the field name itself. The more common mistake is a plural/singular mismatch or extra/missing space:

=A2.Prices        → #FIELD! (should be "Price", singular)
=A2.MarketCap     → #FIELD! (missing space — should be "Market Cap")
=A2."Market Cap"  → Correct

Cause 2: The referenced cell isn't actually a linked data type

If A2 contains plain text that merely looks like a recognized entity but was never actually converted to a Stocks or Geography data type (no small icon appears in the cell), any dot-notation formula referencing it returns #FIELD! immediately, since there's no data card to pull from at all.

Cause 3: The field exists for some entities but not others in the same column

Certain fields are entity-specific — for example, not every stock ticker has a "Market Cap" field populated if it's a very small or delisted company, and not every country has "GDP" reliably available. A formula copied down a column of mixed entities can show #FIELD! for some rows and a valid value for others.

Cause 4: Temporary data source unavailability

Linked data types depend on a live connection to Microsoft's cloud data service. If that service is temporarily unable to serve a particular field (due to a data refresh cycle or a source change on Microsoft's end), formulas that worked previously can intermittently show #FIELD! until the connection refreshes.

5. Fixing #FIELD! in Stocks Data Type

  1. Click directly on the cell containing the stock's linked icon (not the formula cell) to pop up its data card.
  2. Scroll through the card to find the exact field name and spelling you need.
  3. Rewrite your formula using that exact spelling, wrapping multi-word fields in quotes.
  4. If the field genuinely isn't listed on the card for that specific ticker, it may not be available for that security — wrap the formula in IFERROR to handle it gracefully:
=IFERROR(A2."Market Cap", "N/A for this ticker")

6. Fixing #FIELD! in Geography Data Type

The same troubleshooting applies to Geography data types, with one extra wrinkle: some fields (like "GDP") are refreshed on a different schedule than others (like "Population"), so a formula referencing GDP may briefly show #FIELD! immediately after conversion while Excel finishes populating the full data card. Wait a few seconds and force a recalculation (F9) before assuming the field name itself is wrong.

7. When the Cell Was Never Actually Converted

A very common false alarm: typing a country or company name, pressing Enter, and assuming Excel automatically converted it. If no small icon appears to the left of the text, it wasn't recognized. To force conversion:

  1. Select the cell(s) containing plain text entity names.
  2. Go to Data tab → Data Types group → click Stocks or Geography.
  3. Excel will attempt to match each text value to a known entity, showing a small "?" icon for any it couldn't confidently match — click that icon to manually select the correct match from a list of suggestions.

8. Using FIELDVALUE() Directly

As an alternative to dot notation, Excel provides the explicit FIELDVALUE() function, which some users find clearer when field names are stored dynamically (e.g., referenced from another cell rather than typed literally):

=FIELDVALUE(A2,"Price")
=FIELDVALUE(A2,B1)          — where B1 contains the text "Price"

This is functionally identical to dot notation but avoids needing to manually quote field names with spaces, since the field name is passed as a standard text argument.

9. Google Sheets Equivalent

Google Sheets has its own comparable feature via GOOGLEFINANCE() for stock data and does not use Excel's linked data type / dot-notation system at all. There is no direct #FIELD! error in Sheets — the closest equivalent is GOOGLEFINANCE() returning #N/A when an invalid attribute string is passed as its second argument:

=GOOGLEFINANCE("MSFT","pricee")   → #N/A (invalid attribute, note the typo)
=GOOGLEFINANCE("MSFT","price")    → Correct

10. Best Practices

11. Frequently Asked Questions

What is the #FIELD! error in Excel?

The #FIELD! error appears when a formula tries to extract a field name (like Price or Population) from a linked data type card, such as Stocks or Geography, but that exact field name doesn't exist on the card — usually because it was typed incorrectly, the underlying data source changed its structure, or the cell was never actually converted to a linked data type.

How do I see the available field names on a Stocks data type?

Click the cell containing the linked data type icon and a card will pop up listing every available field, such as Price, Change, Market Cap, and 52 Week High. Use the exact spelling and capitalization shown on that card in your formula.

Why did my #FIELD! formula work yesterday but not today?

Linked data types pull live information from Microsoft's cloud service, and the exact set of available fields can occasionally change on Microsoft's end, be temporarily unavailable, or require the data type to be refreshed before the field becomes accessible again.

Does #FIELD! ever mean my data is wrong rather than my formula?

Yes — if a field genuinely isn't populated for a specific entity (for example, a small company with no available Market Cap data), the error reflects a real data gap rather than a formula mistake, and wrapping the formula in IFERROR is the appropriate fix rather than continuing to search for a typo.

Related Guides

Editorial Disclaimer: This guide is developed to the best of our domain knowledge and tested against Excel 2019+, Microsoft 365, and Google Sheets. Content is updated continuously as spreadsheet calculation engines evolve.