Excel Stocks data type not updating? Here's why — and every fix

The Stocks data type does notauto-refresh or stream. It fetches a value once, then holds it until you explicitly refresh. So the most common “not updating” case isn't a bug at all — nothing told it to update. Force a refresh with:

• Data → Refresh All (updates every linked data type in the workbook), or
• Right-click the cell → Data Type → Refresh for a single entry.

There is no “live” toggle. If you need it to update on a schedule, you have to automate the refresh yourself (see below).

Two honest reasons the value can look frozen even after a refresh:

• The prices are delayed. The Stocks data type serves exchange-delayed quotes (commonly 15 minutes or more). A fresh pull can return the same number you already had.
• The market is closed.Outside U.S. regular hours the last price doesn't move, so refreshing changes nothing. (Crypto, which trades 24/7, isn't covered by the Stocks data type at all.)

Then the feature itself is unavailable. Check these in order:

• You need Microsoft 365.Linked data types don't exist in perpetual Excel 2019/2021 or many free web accounts — only in a 365 subscription.
• Connected experiences must be on. File → Options → Trust Center → Trust Center Settings → Privacy Options, and enable “experiences that analyze / download online content.” Many organizations disable this by policy, which greys out data types.
• Editing language / region. Data types are only offered in supported languages (English editing language is the safe one). An unsupported language hides them entirely.
• You must be signed in and online. Data types call a cloud service — no account or no connection means no data.

• #BUSY! — the service is still fetching; usually resolves in a moment. Refresh again if it lingers.
• #FIELD!— you asked for a field the entity doesn't have. Click the data-type icon to see valid fields.
• Wrong match.Excel guessed a different company or index for an ambiguous ticker. Click the cell's icon → select the correct entity, or type the exchange (e.g. XNAS:AAPL) to disambiguate.
• Stuck cell.Convert the cell back to text (Data → “Convert to Text,” or just remove the data type) and re-apply Stocks to re-link it.

Not natively. The common workarounds all just re-run the manual refresh for you:

• A tiny VBA macro that calls Workbook.RefreshAll on a timer.
• Power Queryset to refresh every N minutes (Query Properties → “Refresh every…”).
• A paid streaming add-in (MarketXLS, Finsheet, etc.) that pushes live data into cells.

Even with a macro, you're refreshing a delayed feed — the automation hides the clicking, not the delay.

The Stocks data type is fine for an occasional, delayed glance. If you want prices that stream on their own — without a macro, an add-in, or a Microsoft 365 subscription — a purpose-built live tool is the simpler path.

Fair trade-offs: the Stocks data type lives right inside your Excel workbook and pulls some company fundamentals into cells; a full add-in like MarketXLS adds options and models. Stealth Quotes is a separate spreadsheet-style web app — it doesn't do options chains — but it streams real-time stock and crypto prices with no formulas, no add-in, and no Microsoft 365, in any browser.

Bottom line: an Excel Stocks data type that “won't update” is usually working exactly as designed — manual refresh, delayed data. Once you need prices that move on their own, that's the wall. Stealth Quotes is built for that side of it: open it in a browser, type a ticker, and the live price is just there.