Bing Chat Excel Formula Not Responding?

Formulas & functions · Updated November 18, 2026

If Bing Chat is not responding to an Excel formula, first check whether the problem is the chat tool or Excel itself: Bing Chat, now generally presented as Microsoft Copilot, can suggest or explain a formula, but Excel is the app that calculates it. If Copilot is silent or fails to produce an answer, troubleshoot the chat session; if a formula is already in a cell but shows no result, troubleshoot Excel’s calculation settings, formula entry, or cell contents.

First identify which part is not responding

People use “Bing Chat Excel formula not responding” to describe a few different problems. You might type a request such as “total the sales in column B” and receive no answer. You might get a formula from Copilot but find that Excel displays the formula text instead of a result. Or the formula may appear correctly but show an error, a blank, or an old value. Each situation points to a different fix, so avoid changing workbook settings until you know which one you have.

  • No chat reply: the issue is likely the browser, network, account, service, or chat session.
  • A suggested formula does not work: check that it matches your column layout and Excel’s syntax, then enter it in a worksheet cell.
  • A worksheet result does not update: check calculation mode, cell formatting, and whether the referenced cells contain the expected values.

Also distinguish ordinary Copilot chat from Copilot features inside Excel. A response in a browser chat does not automatically change a workbook open on your computer. In-app capabilities and access requirements can vary by Microsoft 365 plan, account, region, and rollout, so check the options available in your own Excel installation rather than assuming every Copilot chat feature is part of Excel.

How Bing Chat and Excel handle a formula

A chat assistant interprets a request and may write a formula as text. For example, it can suggest a function for adding a range, explain what a formula means, or point out a likely syntax problem. Unless you are using an available in-app Excel feature that explicitly works with the open workbook, that answer is not the same as entering a formula into a cell. Copy the suggestion, select the intended cell in Excel, and paste or type it there.

Excel then parses and calculates the formula using the workbook’s data and settings. A formula can be syntactically valid yet still return an unexpected result if the referenced cells differ from what the prompt implied. For instance, a request to total monthly sales is ambiguous if the sheet has several tables, hidden rows, or separate columns for net and gross sales. Copilot cannot reliably infer every business rule from a short description, so verify the range and meaning before relying on the result.

For a simple check, with the values 12, 8, and 5 in cells B2 through B4, enter =SUM(B2:B4) in an empty cell; Excel should return 25. This confirms that Excel can calculate a basic formula, but it does not prove that a more complex suggestion uses the right data.

Fix a chat that gives no answer

If the request itself is not receiving a response, try these checks before editing your workbook. Microsoft may update the Copilot interface, and button names or available features can differ between the website, Edge, Windows, and Microsoft 365 apps. The basic troubleshooting steps are similar across them:

  1. Check the connection and service. Load another reliable website or Microsoft page. If other services also fail, resolve the connection issue first. If the page loads but Copilot does not respond, wait briefly and try again; a temporary service or network problem is possible.
  2. Start a new chat and simplify the request. Ask one specific question instead of sending a long prompt with several tasks. For example, say which worksheet column contains the values and what result you want. This helps distinguish a confusing request from a stalled session.
  3. Refresh the page or restart the app. Save any workbook changes before closing Excel. In a browser, refresh the Copilot page; if it remains stuck, sign out and back in or try a current supported browser. Avoid repeatedly submitting the same prompt while a response may still be loading.
  4. Check the account and access. Confirm that you are signed in to the intended Microsoft account and that your organization has not restricted the service. Work or school accounts can have administrator-controlled access, and availability is not identical for every account or subscription.
  5. Try a clean browser session. Extensions, blocked cookies, or cached site data can interfere with a web session. A private window can help isolate an extension or stored-session issue, though it may require signing in again.

If Copilot responds to ordinary questions but not to a request about Excel, make the prompt more concrete and provide a small description of the data layout. Do not paste confidential customer, employee, or financial data into a chat unless your organization permits it and you understand the applicable privacy and data-handling terms.

Check Excel calculation and cell display

If the formula is in a worksheet but the answer does not update, first check Excel’s calculation mode. In Excel for Microsoft 365 on Windows, open Formulas > Calculation Options and select Automatic if the workbook is set to Manual. In Manual mode, formulas may retain old results until recalculation is requested. This setting can affect more than the cell you are looking at, so understand the workbook’s requirements before changing it.

Next, check whether Excel is displaying the formula as text. Select the cell and look at the formula bar. If the cell shows the characters of the formula instead of a calculated value, it may be formatted as Text or the entry may have a leading apostrophe. Change the cell’s number format to General, then re-enter the formula so Excel parses it. Merely changing the format may not convert an existing text entry; press F2 and then Enter, or edit and confirm the cell contents.

A quick calculation test can separate a workbook issue from an Excel-wide issue. In an empty cell such as A1, enter =1+1; the expected result is 2. If the cell displays the expression, check its format and whether Show Formulas is enabled. If it displays an old value or does not recalculate, inspect calculation mode. If this simple test works but the original formula does not, focus on that formula’s references and data.

In Excel for the web, the ribbon and settings may be arranged differently from the Windows desktop app, and some workbook features are not identical. Open the workbook in the desktop app if you need a setting or diagnostic option that is unavailable in the browser. On Mac, Excel has its own ribbon and application settings; look for calculation controls in the Formulas tab or Excel settings rather than assuming every Windows menu location is identical.

Read the formula and error carefully

Excel’s visible result often gives a useful clue. A #NAME? error can mean that a function name is misspelled, text lacks quotation marks, or a name used in the formula is undefined. A #REF! error indicates an invalid cell reference, often after referenced cells were deleted. A #VALUE! error commonly points to an incompatible value or argument. A #DIV/0! error means a calculation tried to divide by zero or an empty denominator. These errors do not necessarily mean Copilot itself failed.

Check the formula’s references against the actual sheet. A suggested range may stop one row too early, include a heading, or point to the wrong column. If the formula refers to a table, confirm that the table name and column headings match exactly. If your Excel region uses different list separators, a formula generated with commas may need to be adapted to your local settings; the function names and separator conventions can vary by language and configuration. Do not replace separators blindly if the formula already parses.

For a dynamic-array formula, also check whether the cells where results should appear are occupied. Excel may show a spill-related error if something blocks the output range. For newer functions, verify that your Excel version supports them: functions such as XLOOKUP, FILTER, SORT, UNIQUE, SEQUENCE, and LET require Microsoft 365 or Excel 2021 or later. A formula that works for one person may not work in an older installation.

Ask for a formula that fits the workbook

A useful prompt gives the assistant the workbook structure, the intended result, and any important rule. Instead of “make a total,” say that sales figures are in B2:B20, that row 1 contains headings, and that you want the sum of those figures. For a lookup, explain which column contains the key, which column contains the result, and what should happen when no match exists. This reduces ambiguity, but always confirm that the proposed references match the actual cells.

When a formula fails, include the exact formula, the exact Excel error or displayed result, the relevant cell layout, and your Excel version. Remove private data and replace it with representative sample values where possible. Ask for a plain-language explanation as well as a corrected formula; understanding the references makes it easier to spot a plausible-looking but incorrect answer.

Be cautious with suggestions that use newer functions, macros, or external connections. If you need compatibility with older Excel versions, say so in the prompt and ask for a version-compatible option. If a response proposes a macro, review what it changes before running it, and save a separate copy of the workbook first; macro actions cannot be undone with Ctrl+Z.

Alternatives and sensible checks

You do not need a chat assistant to diagnose every formula problem. Excel’s function autocomplete, formula bar, error indicators, and built-in help can clarify function names and arguments. For a formula in a worksheet, select the cell and use Excel’s formula auditing tools on the Formulas tab to inspect references or evaluate parts of a calculation. For a small range, manually check a few source values and compare them with the expected result.

If you need help from another person, provide a sanitized copy or a small mock-up that preserves the layout and formulas but removes personal or confidential values. This is often more useful than sharing a screenshot without row and column labels. For recurring work, document what each column means and convert a consistent data range into an Excel table; clear structure makes formulas easier to write and verify, whether you use Copilot, Excel help, or a colleague.

Frequently Asked Questions

Does Bing Chat enter a formula directly into Excel?
Not in an ordinary browser chat. It can suggest formula text, which you generally need to copy into a worksheet. An available Copilot feature inside Excel may offer workbook-aware assistance, but access and capabilities depend on the account and product.

Why does Excel show my formula instead of the answer?
The cell may be formatted as Text, the entry may begin with an apostrophe, or Show Formulas may be turned on. Set the cell to General and re-enter the formula; also check the Formulas tab for the formula-display option.

Why is my formula result not changing?
Check Formulas > Calculation Options in Excel for Microsoft 365 on Windows and confirm that calculation is set to Automatic. Also verify that the formula refers to the cells you changed and that those cells contain numeric values where expected.

Why does a formula from Copilot return an error?
The formula may use the wrong range, an unavailable function, a mismatched table or column name, or syntax that does not fit your Excel settings. Read the error, compare the references with the worksheet, and ask for a version-compatible formula using a sanitized description of the layout.

Is Bing Chat the same as Copilot?
Microsoft has moved from the Bing Chat branding to Microsoft Copilot in many experiences. The exact name and features depend on where you access it, but a chat response and Excel’s calculation engine remain separate unless you are using a specific in-app integration.

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.