Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
Fix the #FIELD! error
Excel onlyWhat #FIELD! means
#FIELD! appears in Excel when you try to extract a field from a Linked Data Type — such as Stocks or Geography — and the field name does not exist for that record, the data type failed to resolve, or the cell has not been converted to a Linked Data Type yet. It is Excel-specific and does not appear in Google Sheets.
Common causes
- The cell was not successfully converted to a Linked Data Type — it still holds plain text and the dot notation cannot extract a field.
- The field name in the formula (e.g., .Price, .Population) is misspelled or does not exist for that specific record.
- Microsoft's data service is temporarily unavailable, so field values cannot be fetched for any linked types in the workbook.
- The linked record is ambiguous — Excel showed a disambiguation card and the user did not select a specific match.
- The workbook is offline or the user account does not have a Microsoft 365 subscription that includes Linked Data Types.
Example fix
Broken
=A2.PricFixed
=A2.PriceFixed the misspelled field name from 'Pric' to 'Price'. Field names must match exactly — use the Insert Field picker to avoid typos.
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How to fix it
- 1Click the cell showing #FIELD! and look for the linked data type icon (small icon in the cell corner). If absent, re-select the cell and click Data > Stocks or Data > Geography to convert it.
- 2Check the field name spelling. Use the Insert Field button (the icon that appears when you select a converted cell) to see all valid fields for that record.
- 3If records show a question mark icon, click it to resolve ambiguity and pick the correct entity.
- 4Refresh the data type: select affected cells > Data > Refresh All or right-click > Data Type > Refresh.
- 5Wrap the field reference in IFERROR to show a fallback while the data resolves: =IFERROR(A2.Price,"Unavailable").
Stop hunting errors by hand.
Upload your spreadsheet and the Auditor flags every #FIELD! and broken formula at once — or paste this one formula and get the fix explained.
Frequently asked
My stock data type showed correctly yesterday but now shows #FIELD!. Why?
Microsoft's data service may be temporarily unavailable, or the stock ticker is no longer supported. Try Refresh All. If it persists, check the Microsoft 365 service status.
Can I use #FIELD! data types in Google Sheets?
No. Linked Data Types (Stocks, Geography) are Excel-specific features tied to Microsoft 365. Google Sheets uses GOOGLEFINANCE() for stock data instead.
Is there a way to list all available fields for a Linked Data Type?
Yes. Select the converted cell, click the small icon that appears in the upper-left corner of the cell, and Excel shows a card listing all available fields you can insert.