Quick answer
The most common cause is too many formulas recalculating on every change, along with excess formatting and whole-column references. Switch calculation to manual, limit formula ranges, remove unnecessary formatting, and check whether the problem is the file itself or an Excel add-in.
How to recognize the problem
- The spreadsheet takes several minutes to open or Excel shows "Not Responding" when opening
- Every entry or cursor movement causes a brief freeze
- The status bar at the bottom shows "Calculating" or a calculation percentage
- Scrolling through the sheet stutters and cells populate with a delay
- The file works fine on another computer but not on yours
Most common causes
Automatic calculation over a large number of formulas
By default, Excel recalculates formulas that depend on changes and volatile functions. With tens of thousands of formulas, this can take several seconds.
Whole-column references
Formulas like `SUM(A:A)` or `VLOOKUP` across an entire column can force Excel to scan far more rows than necessary, even when the data is small.
Excess formatting and hidden objects
Formatting entire columns, lots of conditional formatting, images, and comments increase file size and slow down rendering.
Volatile formulas and constant recalculation
Functions like `INDIRECT`, `OFFSET`, and `TODAY` in thousands of rows prevent Excel from caching results.
Add-ins and external links
Third-party add-ins and links to other files or databases can block Excel during opening and refreshing.
Step-by-step fix
- 1
Switch calculation to manual
Go to
Formulas > Calculation Options > Manual. Excel will no longer recalculate on every entry. When you finish changes, pressF9to recalculate all formulas orShift + F9for just the active sheet. - 2
Replace whole-column references
Search for formulas that use
A:Aor1:1and replace them with exact ranges, for exampleA2:A50000. ForVLOOKUPandXLOOKUP, limit the lookup range to the actual data rows. - 3
Remove unnecessary formatting
First make a copy of the file and verify that those rows truly have no data or formulas. Select the empty rows below the data and clear them via
Home > Clear > Clear All, then save the file. Do the same with empty columns to the right of the table. Also checkConditional Formatting > Manage Rulesand delete unused rules. - 4
Convert data into a proper table
Select the data and press
Ctrl + Tto create an Excel table. The table automatically tracks the range, so formulas and pivot tables don't need to scan entire columns. - 5
Disable unnecessary add-ins
Open
File > Options > Add-ins, in theManagebox selectCOM Add-insand clickGo. Disable add-ins you don't use, then restart Excel. If the problem is resolved, enable them one by one to find the culprit. - 6
Check external connections and refresh
Go to
Data > Queries & Connectionsand review the connections. Right-click a query and openProperties, then turn off automatic refresh on open for queries you don't need immediately, or refresh them manually viaData > Refresh All. - 7
Save the file in another format
If the file still runs slowly, save a copy via
File > Save Asin.xlsxformat without macros, if you don't need macros, or create a new file and copy only the data and necessary formulas. Old.xlsfiles and files with years of formatting often carry hidden bloat. - 8
Check computer performance
Close other heavy programs and check in
Task Managerhow much memory Excel is using. If usage is consistently near 100 percent, add RAM or work with a smaller extract of data, for example viaPower Query.
If nothing helps: Power Query and sharing the file
When a table has hundreds of thousands of rows, Excel itself becomes the bottleneck. Then import data via Data > Get Data (Power Query), filter and aggregate it before it enters the sheet, and bring only a summary into Excel. For reports that multiple people open simultaneously, consider saving to SharePoint or OneDrive and working in Excel for the web, which doesn't load all formulas locally. If the file must remain large, work with a copy without macros and save the original as a backup before any major change.
How to prevent it
- Use exact ranges instead of whole columns in formulas
- Keep formatting only on rows with data
- Occasionally check the add-ins list in `File > Options > Add-ins`
- Import large sources via Power Query and aggregate before displaying
When to call a professional
If Excel crashes, the file is larger than 100 MB, or contains macros and database connections, further cleaning may damage data. In that case, it's better for IT support to review the file, add-ins, and calculation settings.
IT infrastructure maintenance · Servers, networks, backup, security and helpdeskFAQ
Can manual calculation corrupt data?
No, but formulas won't show new results until you press `F9`. If you forget to refresh, you may work with stale numbers, so always press `F9` before printing or sending.
Why does the file open slowly only on my computer?
The cause is likely an add-in, insufficient RAM, or a slow connection to a network folder. Open the same file on another computer and compare behavior to determine whether the problem is the file or the environment.
Is it safe to delete formatting from empty rows?
Yes, if those rows are truly empty. Before deleting, make a copy of the file via `File > Save As`, then apply `Clear All` in the copy and verify that data and formulas remain intact.