How to Unstick a Spreadsheet That Says Calculating Forever

The status bar says Calculating, the percentage barely moves, and the workbook will not respond to clicks. Excel is recalculating every formula in the file, and something in the file makes that take minutes instead of a fraction of a second. The fix is to stop the recalculation, switch to manual mode, and remove the formulas doing the damage.

Press Esc to interrupt

Press Esc once and wait a few seconds. Excel checks for Esc between calculation steps and usually hands control back. If nothing happens after a minute, open Task Manager (Windows) or Activity Monitor (Mac). If Excel's CPU use is high, it is still working and will likely finish. If it sits at zero, Excel is hung; force-closing it is the only option, and unsaved changes are lost.

Switch to manual calculation

Go to Formulas, Calculation Options, Manual. Excel now recalculates only when you press F9 (Mac: Cmd + =). You can edit, save, and move around while you track down the cause. Turn Automatic back on once the file is fixed.

Find the formulas doing the damage

The usual culprits, in order of likelihood:

• Whole-column references such as A:A inside SUMIF, COUNTIF, VLOOKUP, or SUMPRODUCT, copied down thousands of rows. Each copy scans a million cells.
• Volatile functions: NOW, TODAY, OFFSET, INDIRECT, RAND, RANDBETWEEN. They recalculate on every edit, along with everything that depends on them.
• Array formulas that spill across large ranges.
• Conditional formatting with dozens of rules.
• Links to other workbooks, listed under Data, Edit Links.

Press Ctrl + F (Mac: Cmd + F), set Look in to Formulas, and search for A:A, OFFSET(, or INDIRECT( to locate them.

Replace the slow formulas

Change whole-column references to exact ranges such as A2:A5000, or convert the data to a Table with Ctrl + T (Mac: Cmd + T) so ranges grow with the data. Swap OFFSET and INDIRECT for INDEX where possible. For results that no longer need to update, copy the cells and use Home, Paste, Paste Values. Remove dead links under Data, Edit Links, Break Link.

Save as a binary workbook

For large files, use File, Save As and choose Excel Binary Workbook (.xlsb). It opens and saves faster than .xlsx with the same formulas. Save a copy under a new name before the surgery above so the original stays intact.

If this is Google Sheets. The equivalent symptom is cells stuck on Loading. The cause is almost always a chain of IMPORTRANGE, QUERY, or ARRAYFORMULA calls, and the fix is the same: shorten the ranges and paste values over results that do not need to stay live.