Bing Chat Excel Formula Not Updating? Fixes That Work

Formulas & functions · Updated November 21, 2026

If a formula from Bing Chat is not updating in Excel, first check that it was entered as a real formula and that Excel is set to calculate automatically: in Windows, open File > Options > Formulas and select Automatic under Workbook Calculation. Bing Chat’s suggested text does not stay connected to your workbook; Excel recalculates a formula only after you enter it in a cell and its references or calculation conditions change.

What a Bing Chat formula can—and cannot—do

Bing Chat, now part of Microsoft Copilot, can suggest a formula when you describe your data and the result you want. A chat response is advice, not a live formula link. Copying a result from the chat into Excel will not make it respond to later changes in your sheet. To get a dynamic result, enter the suggested expression into an Excel cell as a formula, with an equals sign at the start, and make sure its references point to the cells that contain your data.

For instance, a request such as “total the values in B2 through B4” could produce a suitable formula. With the numbers 10, 15, and 20 in B2:B4, enter =SUM(B2:B4) in another cell; the result is 45. If B3 changes to 18, the result becomes 48 when Excel recalculates. The formula itself is in the workbook; the chat response is not.

Some Microsoft 365 plans and Excel versions offer Copilot features inside Excel, but availability depends on the account, license, application, and rollout. Even when a feature can help create or explain formulas in a workbook, the cell formula—not the chat transcript—is what calculates the result. If you are using ordinary Bing Chat in a browser, assume that it cannot inspect or update your open workbook unless you explicitly provide the relevant data or use a supported connected feature.

Set Excel to calculate automatically

Excel normally recalculates dependent formulas when their referenced values change. If calculation was switched to Manual, a cell can continue displaying an older result until you recalculate. This setting can be carried with workbooks, so a file created or edited elsewhere may behave differently from a new workbook.

  1. In Excel for Microsoft 365 on Windows, select File > Options > Formulas.
  2. Under Calculation options, select Automatic for Workbook Calculation, then select OK.
  3. Change an input cell and see whether the result updates. Press F9 to recalculate open workbooks if needed. Press Ctrl+Alt+F9 to force a full calculation.

On a Mac, open Excel > Settings (called Preferences in some releases), then choose Calculation and set calculation to Automatic. The location and label can vary slightly by Excel release. On a Mac keyboard, F9 may require the Fn key or a change to the keyboard’s function-key setting. In Excel for the web, check the Formulas tab for calculation options if they are available in your version.

Manual calculation can be useful in a very large workbook because recalculating many formulas can take time. It is also a common reason for apparently stale results. Changing the mode may affect other workbooks open in the same Excel session, so check whether another open file depends on Manual calculation before changing it.

Make sure the cell contains a formula, not text

A formula pasted into a cell formatted as Text may appear on screen exactly as typed instead of calculating. A leading apostrophe can have the same effect. Another possibility is that Show Formulas is turned on, which displays formulas in cells rather than their results. These are different problems: a text entry is not being evaluated, while Show Formulas only changes what Excel displays.

  • Select the cell and look at the formula bar. If the content starts with an apostrophe or the cell was set to Text, it may be stored as text.
  • Change the cell format to General using Home > Number Format, then re-enter the formula. Merely changing the format may not convert an existing text entry; edit the cell and press Enter.
  • If many cells show expressions instead of results, turn off Formulas > Show Formulas, or use Ctrl+` on Windows. The grave-accent key is usually near the upper-left of the keyboard.

For a simple check, with the number 6 in A1, enter =A1+1 in B1. The expected result is 7. If B1 displays the characters of the expression, check the cell format, any leading apostrophe, and Show Formulas before asking Bing Chat for a different formula.

Check references and the values being referenced

A formula can calculate correctly and still appear not to update because it points to the wrong cells, excludes a new row, or depends on an input that has not actually changed. Click the formula cell and inspect the colored reference outlines or formula bar. Confirm that the referenced range covers the full data set and that the input cells contain the values you expect.

For example, with a unit price of 12 in B2 and a quantity of 3 in C2, enter =B2*C2 in D2; the result should be 36. If the quantity is later changed to 4, D2 should show 48. If it remains 36, check whether C2 is really the quantity cell, whether the formula was replaced by a pasted value, and whether calculation is automatic.

References can also be fixed intentionally. A reference such as $B$2 remains anchored when a formula is filled across or down, while a reference such as B2 adjusts relative to its new location. If a formula generated in chat is copied to other rows, ask whether each reference should move with the row or remain fixed. A misplaced dollar sign can make a formula appear to ignore changing inputs.

Finally, formulas may depend on inputs that look numeric but are stored as text, or on dates entered as text rather than recognized dates. Check the cell contents and number formats, and try re-entering a sample value. Formatting a cell as a number does not always convert text that was already entered.

Do not confuse recalculation with refreshing data

Excel recalculation and data refresh solve different problems. Recalculation updates formulas using values already present in the workbook. Refresh retrieves new information from a source such as a query, linked workbook, or external data connection. Pressing F9 will not necessarily fetch new records from a website, database, or Power Query connection.

If the source data itself is old, use Data > Refresh All in Excel for Windows, or refresh the specific query or connection from the Data tab. Wait for the refresh to finish, then check the formulas that use the refreshed table. Some connections have their own refresh settings, authentication requirements, or errors; a formula cannot display data that the connection failed to retrieve.

There is a similar distinction with functions such as TODAY. With today’s date in the workbook environment, enter =TODAY() in a cell to return the current date recognized by Excel. It is a volatile function, so it can update when Excel recalculates, but it does not continuously change every second. If you need an external price or live feed, TODAY is not a substitute for refreshing a data source.

Check for formula errors and version limits

If Excel shows an error rather than an old value, the formula may be syntactically invalid, reference a missing sheet, use an unsupported function, or receive data in an unexpected form. Bing Chat can suggest a function that is unavailable in your Excel edition or write a reference that does not match your workbook. A formula that looks plausible should still be checked against the names of your sheets, tables, and columns.

Basic functions such as SUM are broadly available, but newer functions may require Microsoft 365 or a recent perpetual release. For example, XLOOKUP, FILTER, SORT, UNIQUE, SEQUENCE, and LET require Excel 2021 or Microsoft 365; functions including TEXTSPLIT, TEXTBEFORE, TEXTAFTER, VSTACK, HSTACK, and LAMBDA require Microsoft 365 or Excel 2024. If Excel reports an unrecognized function, confirm your version and update status before assuming recalculation is broken.

Regional settings can also affect how formulas are entered. The examples here use commas between function arguments, as requested for standard English-language syntax. In some regional configurations, Excel expects semicolons instead. If Excel rejects a formula at entry, check the separator expected by your installation and the exact spelling of sheet or table names.

A quick troubleshooting order

Work through these checks before replacing a formula or rebuilding the workbook. They separate the most common causes and help identify whether the issue lies in the chat suggestion, the cell, calculation mode, or an external data source.

  1. Click the result cell and verify that it contains a formula beginning with an equals sign, rather than a pasted answer or text.
  2. Check that the references point to the intended cells and include every relevant row.
  3. Confirm that the source cells have changed and contain usable values, not numbers stored as text.
  4. Set Workbook Calculation to Automatic, then press F9. Use Ctrl+Alt+F9 for a full calculation on Windows if necessary.
  5. If the formula uses imported data, refresh the relevant connection separately with Data > Refresh All.
  6. Look for an error message or an unsupported function, and check whether the workbook is in Show Formulas mode.

For a useful follow-up prompt to Bing Chat, describe the cell layout, the exact formula, the expected result, and the result Excel actually shows. Remove confidential data before sharing it. A prompt such as “Dates are in A2:A20 and amounts are in B2:B20; this formula shows a value that does not change after B5 changes” is more actionable than “my formula is broken.”

Frequently Asked Questions

Does Bing Chat update Excel formulas automatically?

No. A response in a chat is not linked to a workbook cell. Enter a formula in Excel and make sure it refers to the cells that should drive the result. Supported Copilot features inside Excel may assist with workbook tasks, but the formula in the sheet is what recalculates.

Why does my formula show instead of its answer?

The cell may be formatted as Text, the entry may have a leading apostrophe, or Show Formulas may be enabled. Set the cell to General and re-enter the expression; if formulas across the sheet are visible, turn off Formulas > Show Formulas.

Will pressing F9 refresh data from the internet?

Not necessarily. F9 recalculates formulas from data Excel already has. Use Data > Refresh All for supported workbook connections, and resolve any connection or sign-in errors if the source does not update.

Why does the formula update in one workbook but not another?

The workbooks may have different calculation settings, or one may contain an external connection or unsupported function. Check each workbook’s calculation mode, references, and data-refresh status rather than assuming the formula text alone explains the difference.

Can I ask Bing Chat to fix a formula without sharing the workbook?

Yes. Provide a sample cell layout, the current formula, the intended result, and any error message. Use made-up or anonymized values if the workbook contains sensitive information; the assistant cannot infer private cell contents that you have not supplied or made available through a supported Excel feature.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.