# Set Excel Calculation to Manual for Big Sheets

- Author: FastBankConvert (https://fastbankconvert.com)
- Published: 2026-10-17
- Category: Speed, size and limits
- Canonical: https://fastbankconvert.com/blog/set-excel-calculation-to-manual

> Set Excel calculation to manual while cleaning a big converted sheet, recalculate when you choose, and avoid forgetting it is switched off.
To set Excel calculation to manual, go to Formulas, then Calculation Options, and choose Manual, or set it under File, Options, Formulas. Excel then stops recalculating after every edit, so large converted sheets stay responsive. Press F9 to recalculate when you are ready, and switch back to Automatic before you trust or share any totals.

## How do you set Excel calculation to manual?

On the ribbon, open the Formulas tab, click Calculation Options and choose Manual. The same setting lives under File, then Options, then Formulas, in the Calculation options section, where you pick Manual under Workbook Calculation. Either route takes effect at once, and the status bar shows "Calculate" when results are out of date.

Microsoft's page on [changing formula recalculation in Excel](https://support.microsoft.com/en-us/office/change-formula-recalculation-iteration-or-precision-in-excel-73fc7dac-91cf-4d36-86e8-67124f6bcce4) describes the Options route. It also notes that choosing Manual turns on "Recalculate workbook before saving" automatically, so Excel updates the results each time you save.

A clean-up session on a large converted statement might run like this:

1. Open the converted workbook and switch calculation to Manual.
2. Do the slow edits: delete junk rows, fill blank dates, split columns, paste values.
3. Press F9 to recalculate and check the totals against the statement.
4. Switch calculation back to Automatic.
5. Save the file.

Manual mode helps most when each edit triggers a long pause. On a converted year of transactions with running balance formulas or lookups in every row, each deleted row can make Excel recompute thousands of cells. In manual mode it waits until you ask.

## Recalculating a manual Excel workbook with F9 keys

In manual mode, Excel recalculates only when you press a recalculation key. F9 updates every open workbook, Shift+F9 updates only the active sheet, and Ctrl+Alt+F9 recalculates every formula in every open workbook, whether or not it has changed. Use Shift+F9 to check one sheet quickly and F9 before reading final totals.

The table sums up the three keys as Microsoft's recalculation page describes them:

| Keys | What it recalculates |
| --- | --- |
| F9 | Formulas changed since the last calculation, and formulas that depend on them, in all open workbooks |
| Shift+F9 | The same, but only in the active worksheet |
| Ctrl+Alt+F9 | All formulas in all open workbooks, changed or not |

F9 is the one to use most of the time. Ctrl+Alt+F9 is slower and is worth pressing when a result looks wrong even after F9, which can happen after large structural edits.

## Does manual calculation apply to every open Excel workbook?

Yes, in desktop Excel. Calculation mode is an application setting while files are open, so switching to manual affects every workbook you have open, not just the converted one. Microsoft's page says changing these options affects all open workbooks. In Excel for the web, the setting applies only to the current workbook.

This matters when you keep a budget or a reconciliation open beside the converted statement. Switch to manual for the clean-up, and those other files stop updating too. A figure you copy from one of them during that time may be out of date. Close the other workbooks first, or recalculate before copying anything out of them.

The mode can also travel with files. If a workbook from someone else shows "Calculate" on the status bar soon after you open it, check Calculation Options before you trust any of its totals, because the sender may have left it on Manual.

## Forgetting Excel calculation is switched to manual

The risk of manual mode is stale numbers. With calculation off, a total or running balance keeps showing its old value after you change the data under it, and nothing on the cell itself warns you. The only signal is "Calculate" in the status bar. Switch back to Automatic as soon as the heavy edits are done.

A few habits keep this from biting:

- **Check the status bar before reading totals.** "Calculate" means at least one result is out of date.
- **Recalculate before copying figures out.** A balance pasted into an email or another file keeps the stale value for good.
- **Turn Automatic back on before saving a copy for others.** Someone else opening your file inherits the setting and may not notice it.
- **Recalculate before sharing a link.** If the results go to a shared sheet, check them first; [sharing a Google Sheet as view only](/blog/share-google-sheet-view-only) covers hiding account details at the same step.

Leaving "Recalculate workbook before saving" switched on is a cheap safety net. Clearing it makes saving a large file faster, but then the saved file can hold out-of-date results.

## When manual calculation will not speed up a converted sheet

Manual calculation only helps when formulas are the bottleneck. A converted sheet of plain values, with no formulas, has nothing to recalculate, so switching modes changes nothing. Slowness there comes from formatting spread over a million rows, a huge pasted range, or conditional formats, and needs a different fix.

Check what the sheet contains before reaching for this setting. Press Ctrl+End to see where Excel thinks the data ends, and look for full-column formulas or conditional formatting rules. If the sheet is all values, the speed problem is elsewhere.

Time spent before Excel matters as well. A converter that produces clean columns removes most of the clean-up edits in the first place. [What happens in one click PDF to Excel](/blog/one-click-pdf-to-excel) and [why a drag and drop PDF converter saves time](/blog/drag-and-drop-pdf-converter) look at that end of the job. FastBankConvert, which is getting ready to open, is built to hand back a sheet with dates, descriptions, amounts and balances already in their own columns; [the homepage shows a sample](/).