Copilot in Excel Will Not Update the Result? Check Calculation Mode First

Copilot in Excel can suggest or change a formula, but the displayed number may stay stale if the workbook is set to manual calculation. That is a workbook setting problem, not a reason to keep rewriting the prompt.

This guide gives you a small order sheet and a check note. The goal is to decide whether a result refreshed correctly before you use it in a report. The data and expected result are fictional.

Evidence label: documentation-based and illustrative. Microsoft documents that Copilot editing in Excel supports Automatic calculation, and that Copilot can explain formulas. The workbook, prompts, and expected output below are fictional. No Copilot run is claimed.

What you will make

You will create a calculation check note with:

• the source rows and expected total
• the workbook calculation setting
• the formula or result that Copilot changed or explained
• a refreshed value checked against the source rows
• a decision to use, correct, or stop

The decision is whether the workbook is ready for human review. It is not proof that Copilot’s formula is correct.

Before you start

You need Excel with Copilot available on your account and a workbook you are allowed to use. Use a blank practice workbook or a copy of an approved file. Do not use payroll, customer, bank, or other sensitive data for this exercise.

Microsoft’s current Copilot in Excel help says editing requires Calculation Options set to Automatic. Menu names and feature access can vary by Excel version, plan, and workspace. If Copilot is missing, fix access first. Changing the calculation setting will not create access.

Fictional input

Open a blank workbook. On a sheet named Orders, paste this tab-separated block into cell A1. Check that it fills columns A through D, rather than one column:

Order ID	Units	Unit price EUR	Expected line total
O-301	4	25	100
O-302	3	40	120
O-303	2	75	150
O-304	5	18	90

In E1, type Calculated line total. Enter =B2*C2 in E2 and fill it down through E5. In E7, enter =SUM(E2:E5); this is the displayed total you will check after recalculation. Keep column D as a separate reference, not an input to the formulas.

The expected total is 460 EUR. Keep that figure in a separate note. It is a hand-calculated check, not a result from Copilot.

Three steps

1. Check calculation mode before asking Copilot to edit

1. Select Formulas > Calculation Options.
2. Check whether Automatic is selected.
3. If Manual is selected, switch to Automatic in the practice copy.
4. Press F9 to recalculate the workbook.
5. If the option is unavailable or the label differs, use your Excel version’s calculation settings and record what you changed.

Do not change the source workbook just to test this. Work in a copy.

2. Ask Copilot for an explanation, not a blind fix

1. Select a cell outside the pasted range, such as A8.
2. Open Copilot in Excel and choose chat mode, which keeps its response in chat rather than editing the workbook. If your version has no clear chat-only option, stop at the manual formula check instead of granting edit permission.
3. Paste this prompt:

Use only the Orders range on this sheet.

I am checking a stale-looking total. Do not change the workbook yet.

Tell me:
1. whether the range has four order rows;
2. which columns contain Units and Unit price EUR;
3. the formula you would use for a line total and a grand total;
4. whether the displayed result could be stale if calculation mode is Manual.

Show the source rows used. Do not invent a cause, a saving, or a business conclusion. If you cannot read the range, say what is missing.

4. If Copilot proposes a formula, write it in the check note first. Do not insert it into the source range until you have reviewed it.
5. If Copilot explains an existing formula, copy the formula exactly as shown in the formula bar into the note.

3. Refresh and compare the result

Complete this note:

Workbook: Orders practice copy
Calculation mode before check: [Automatic / Manual / UNKNOWN]
Formula reviewed: [exact formula or UNKNOWN]
Rows used: [O-301, O-302, O-303, O-304 or the actual rows]
Independent total: 460 EUR
Displayed total after F9: [value or UNKNOWN]
Decision: [USE IN REVIEWED COPY / CORRECT THEN RECHECK / STOP]
Reviewer note: [what still needs checking]

Then check the source yourself:

1. Calculate the four lines: 4 x 25, 3 x 40, 2 x 75, and 5 x 18.
2. Add the line totals: 100 + 120 + 150 + 90 = 460 EUR.
3. Confirm the formula includes all four rows and uses Units and Unit price EUR.
4. Confirm that the formula does not include the expected total note in its own range.
5. Only after those checks, put a corrected formula in the practice copy and press F9 again.

Checkable artifact

Your note should contain the calculation mode, exact formula, four order IDs, independent total, refreshed value, and a reviewer decision. Someone else should be able to repeat the check without asking Copilot another question.

An illustrative formula for a line total could multiply B2 by C2, then a grand total could add the four line totals. That is an editor-written example, not a formula generated in a recorded Copilot session.

Acceptance checks

The workflow passes when:

• Automatic calculation is selected, or the reason it cannot be selected is recorded;
• all four order IDs appear exactly once;
• the formula uses the correct quantity and price columns;
• the independent arithmetic equals 460 EUR;
• the displayed value is checked after recalculation;
• the source range stays unchanged until a person approves a correction;
• the note contains a clear decision and a remaining human check.

Troubleshooting

The displayed value does not change after F9. Check that the workbook is not still in Manual mode, that calculation is not set to a partial option, and that the formula references the intended cells. If the value remains unclear, stop and use the independent check.

Copilot says it cannot edit the workbook. Confirm that you are in a supported Excel surface, that Copilot is available for the account, and that the workbook is saved where your organisation allows it. Do not claim that a formula was changed when no edit occurred.

Copilot gives a formula with the right total but the wrong range. Reject it or correct it in the practice copy. A matching number does not prove that the formula will remain correct when a row is added.

The calculation options are locked. Record the setting and ask the workbook owner or administrator. Do not bypass an organisation policy to complete the exercise.

Copilot suggests a business explanation for the number. Keep the formula check separate from the business interpretation. The four fictional rows contain no evidence about demand, performance, or cause.

Limits and decision

This check can reveal a stale calculation or a wrong range. It cannot prove that a workbook’s definitions, inputs, or business assumptions are sound. Copilot output can be inaccurate, so review formulas and values against the source before relying on them.

TRY this on a fictional sheet or an approved copy when you can calculate the expected value yourself.

SKIP Copilot when the workbook surface, calculation setting, or data boundary is controlled by someone else and you cannot verify the result. Use ordinary Excel checks and ask the owner for access.

USE the result only after the formula, refreshed value, source rows, and decision note agree.

For a related formula review, see Copilot in Excel Suggests the Wrong Total? Trace the Formula Before You Use It. The next task is to compare the checked total with the report period before sharing it.

Want one practical AI-for-work lesson each week? Join The Weekly Verdict.

Sources

• Microsoft Support: Frequently asked questions about Copilot in Excel
• Microsoft Support: Understand formulas with Copilot in Excel
• Microsoft Support: Fix an inconsistent formula