Quick Fix Summary
Hit Ctrl + Alt + F9 if Excel formulas won’t budge. If that doesn’t work, hunt down circular references under Formulas tab → Error Checking → Circular References. For files that won’t open, try File → Open & Repair.
What's Happening
Excel formulas aren’t calculating because calculation mode is stuck on manual, circular references are gumming up the works, or the file itself is corrupted.
You’ll usually spot this when cells show old values or just refuse to update. As of 2026, Excel 365 (Version 2312 or later) defaults to automatic calculation, but someone might’ve flipped the switch back to manual—or you’re opening a legacy file that still thinks manual is cool.
Step-by-Step Solution
Switch to automatic calculation, hunt down circular references, force a full recalc, repair corrupted files, and update Excel.
Now, let’s walk through each step:
- Switch to Automatic Calculation Head to File → Options → Formulas. Under Calculation options, pick Automatic. Hit OK and watch Excel spring back to life.
- Check for Circular References Pop over to Formulas → Error Checking → Circular References. Excel will point out the troublemaker. Fix or delete the loop, then smash F9 to recalculate.
- Force a Full Recalculation Sometimes Excel gets lazy with incremental updates. Press Ctrl + Alt + F9 to bully every formula into updating at once.
- Repair Corrupted Files Fire up Excel, go to File → Open → Browse. Grab your corrupted file, click the dropdown next to Open, and pick Open and Repair.
- Update Excel Make sure you’re not running an ancient build. Check File → Account → Update Options → Update Now. Anything pre-2024 might still have those pesky calculation bugs.
If This Didn’t Work
Re-enable add-ins, reset Excel’s settings, or run the Inquire add-in to find hidden calculation bottlenecks.
Sometimes the problem hides in plain sight:
- Re-enable Add-ins Disabled add-ins can throw a wrench in the works. Zap over to File → Options → Add-ins → Manage Excel Add-ins → Go. Turn them back on one by one until you spot the conflict.
- Reset Excel Settings Corrupted settings love to mess with your head. Reset everything via File → Options → Advanced → Reset all Excel settings. Just know this wipes custom fonts, ribbon layouts, and other tweaks you’ve made.
- Use the Inquire Add-in Excel’s Inquire tool (enable it under File → Options → Add-ins → COM Add-ins → Inquire) digs into your workbook’s dependencies and flags calculation bottlenecks. Run Workbook Analysis for a full diagnostic.
Prevention Tips
Set new workbooks to automatic calculation, audit formulas regularly, enable AutoSave, and limit volatile functions to keep Excel running smoothly.
Honestly, this is the best way to avoid future headaches:
- Automate Calculation Early Always set new workbooks to Automatic mode. Save manual mode for those rare cases where you’re dealing with volatile datasets—like stock prices that change every second.
- Audit Formulas Regularly Use Formulas → Formula Auditing → Trace Precedents/Dependents to map out your formula relationships. If you spot circular references, break them by moving iterative calculations to a separate sheet.
- Enable AutoSave and Cloud Backups Turn on AutoSave (File → Account → Save) and stash critical files in OneDrive or SharePoint. Since 2026, Excel plays nice with Microsoft 365’s version history, so you can roll back to a stable version if things go sideways.
- Limit Volatile Functions Swap out volatile functions like TODAY() or NOW() for static values or structured tables. Volatile functions force recalculations on every tiny change, which slows everything down.
