If Excel is lagging or shows Not Responding, first give it a moment to finish calculating or refreshing, then save if it recovers. If the problem repeats, open Excel in Safe Mode, check whether one workbook or add-in is responsible, and troubleshoot the workbook before forcing the app to close.
Start with a safe, quick check
A brief pause does not always mean Excel has crashed. A large formula recalculation, a Power Query refresh, opening a file from a network location, or loading a data connection can temporarily make the window unresponsive. Look at the status bar and, on Windows, Task Manager: ongoing CPU or disk activity can indicate that work is still happening. Avoid repeatedly clicking the window, which can queue extra commands.
Try these checks in order:
- Wait a minute or two, especially after opening a large file or starting a refresh. The right wait depends on the workbook and computer.
- If the workbook responds, press Ctrl+S to save. On a Mac, use Command+S. If it is stored in OneDrive or SharePoint, confirm that saving or syncing has completed.
- Close other demanding applications and unnecessary Excel workbooks, then try the problem again.
- If Excel remains unresponsive, use Ctrl+Shift+Esc to open Windows Task Manager. Check whether Excel is still using CPU or memory before deciding to end the task.
Ending Excel can lose changes that have not been saved. If you must close it, reopen Excel afterward and look for the Document Recovery pane or recovered files. AutoRecover may help, but it is not a guarantee that every unsaved change can be restored.
Work out whether Excel or one workbook is at fault
Test Excel with a blank workbook. Start Excel without opening the troublesome file, then create a blank workbook and enter a few values. If that works smoothly while one particular file freezes, the workbook is the leading suspect. If even a blank workbook is slow, look at add-ins, the Office installation, Windows resources, or other software.
On Windows, press Windows key+R, type excel /safe, and press Enter to launch Excel in Safe Mode. If Excel runs normally there, an add-in or customized startup component may be involved. Safe Mode is a diagnostic test, not a permanent fix: it temporarily limits certain features and does not prove which add-in is responsible.
In normal Excel, go to File > Options > Add-ins. At the bottom, select COM Add-ins beside Manage and choose Go. Clear selected add-ins, restart Excel, and test again. If the issue stops, re-enable add-ins one at a time, restarting as needed, to identify the likely cause. Excel add-ins are managed separately, so use the Manage list to select Excel Add-ins and choose Go if needed. On Mac, add-in controls and Safe Mode steps differ; consult the instructions for the particular add-in and your Excel version.
Check what the workbook is doing
A workbook can be slow because it asks Excel to perform far more work than is visible on the screen. Large ranges used in formulas, many linked workbooks, complex conditional formatting, numerous shapes, and extensive formatting can all add overhead. Data connections and PivotTables may also take time to refresh. A workbook that is slow only while refreshing may be waiting on a server or data source rather than struggling with ordinary cell editing.
Make a separate copy before changing a complex file. Then test one change at a time:
- Use Find to look for formulas that refer to entire columns when they only need a limited range. Whole-column references can be convenient, but repeated complex calculations over very large ranges may increase work.
- Review conditional formatting rules for rules applied to much larger areas than necessary. Select a relevant cell and use Home > Conditional Formatting > Manage Rules to inspect rules.
- Check whether the workbook contains external links or formulas that depend on other large files. Open Data > Workbook Links when that command is available, and verify that linked files are accessible and necessary.
- If the delay starts during a refresh, use Data > Queries & Connections to review queries and connections. Do not disable a business-critical refresh without confirming what data the workbook needs.
- Look for an unexpectedly large used range: formatting applied far below or beside the actual data can make a file larger and harder to manage.
Saving a copy under a new name can help determine whether a file-specific issue persists, but it does not automatically repair damaged content. If a workbook behaves abnormally, try Excel’s File > Open dialog, select the file, use the arrow beside the Open button, and choose Open and Repair if that option is offered. Work on a copy so the original remains intact.
Review calculation settings and formulas
Excel normally calculates formulas automatically. If a workbook is set to manual calculation, formula results may not update until recalculation is requested; that can look like a freeze or, conversely, make editing feel faster while results are stale. Check Formulas > Calculation Options. If the workbook should update as values change, choose Automatic. Calculation mode can affect other open workbooks too, so confirm the setting rather than changing it casually.
For a controlled test, press F9 to recalculate open workbooks, or Shift+F9 to calculate the active worksheet. Ctrl+Alt+F9 forces a full calculation. These commands may make a large workbook busy for a while; save first if Excel is responsive. On a Mac, keyboard shortcuts can differ by keyboard and Excel version, so use the equivalent calculation command shown in Excel’s menus or help rather than assuming the Windows key combination applies.
Formula patterns can also explain slow calculation. Repeated volatile functions such as NOW or TODAY recalculate frequently, while complex formulas copied across very large ranges can multiply the work. Avoid replacing formulas with values unless the workbook’s purpose permits it: doing so removes the live calculations. A useful improvement is often to reduce the range or simplify the calculation while preserving the data and outputs the workbook requires.
Check memory, storage, and file location
Excel competes with other applications for computer memory and processing time. Close unused browser tabs, large applications, and duplicate workbooks, then check whether performance improves. Task Manager can show whether Excel or another process is consuming substantial resources. A computer low on free disk space can also have broader performance and saving problems, so check available storage rather than assuming the workbook itself is the only cause.
Compare a local copy with the original if the file is on a network drive, removable device, or cloud-synced folder. If the local copy performs well but the original is slow, the connection, sync activity, permissions, or remote storage may be contributing. Do not treat the local copy as the authoritative file until you understand how to save changes back without creating conflicting versions. For a shared workbook, ask whether other users or automated processes are editing or refreshing it at the same time.
File size alone does not diagnose the issue. A smaller workbook can still have expensive formulas or a slow connection, while a large file may open smoothly on suitable hardware. Compare the same task under similar conditions and note whether the delay occurs when opening, typing, recalculating, saving, or refreshing. That detail narrows the cause far more than the size number by itself.
Update or repair Microsoft 365
If blank workbooks are slow and Safe Mode does not improve matters, install available Office updates. In Excel for Microsoft 365 on Windows, go to File > Account > Update Options > Update Now. The exact options can vary if an organization manages updates. Restart Excel after updating and retest the same file.
If the problem continues, use Windows Settings to repair Office: open Settings > Apps > Installed apps, find Microsoft 365, choose its three-dot menu, select Modify, and follow the repair options presented. Quick Repair is the less extensive first option; Online Repair is more thorough and may take longer or require an internet connection. Save your work and close Office apps before repair. On Mac, Office repair and update procedures are different; use Microsoft AutoUpdate and the current Microsoft support instructions for that installation.
Reduce the chance of another freeze
Prevention is mostly about making files easier to calculate, refresh, and recover. Save important work regularly, keep a separate backup of critical workbooks, and avoid editing the only copy of a file while testing repairs. For a workbook that contains essential data, confirm that the backup opens and that formulas or connections still behave as expected.
- Use bounded data ranges and Excel tables where appropriate instead of applying calculations or formatting to vast unused areas.
- Remove obsolete links, queries, styles, and formatting only after confirming they are no longer needed.
- Refresh external data deliberately and check whether the source is available before a deadline.
- Keep Microsoft 365 and Windows up to date, subject to your organization’s update policy.
- Record what triggers the slowdown and what changed recently, such as a new add-in, a larger data import, or a workbook move.
For workbooks used by a team, document the data sources and calculation assumptions. A workbook that depends on an inaccessible network location may appear broken to another person even when its formulas are intact. If the file is business-critical, involve the workbook owner or IT support before removing connections or changing shared settings.
Frequently Asked Questions
Why does Excel say Not Responding but then recover?
Excel may be busy with a calculation, refresh, save, or other long operation. Windows can label a window Not Responding when it is not processing input promptly; that message by itself does not prove Excel has crashed. Wait and check for ongoing activity before ending the task.
How do I stop Excel from freezing when I type?
First test a blank workbook and then test the affected file. If only one workbook freezes, inspect formulas, conditional formatting, links, and connections. If all workbooks are affected, test Safe Mode, disable add-ins methodically, and check available system resources.
Will I lose my work if I force close Excel?
You can lose changes made since the last save. Recovered files or AutoRecover may contain some recent work, but recovery is not guaranteed. Save with Ctrl+S on Windows or Command+S on Mac whenever Excel responds, and keep backups of important files.
Does a bigger Excel file always cause lag?
No. File size is only one clue. Formula complexity, used ranges, add-ins, data refreshes, storage location, and available computer resources can matter more. Identify the action that triggers the delay instead of relying on file size alone.
Why is Excel slow only when I open one file?
That often points to workbook-specific work such as recalculation, external links, queries, formatting, or damaged content. Make a copy, compare it with a blank workbook, and test likely causes one at a time. If the file is shared or business-critical, ask its owner before changing connections or deleting content.
Related
- Excel Hide Specific Columns: Steps and Tips
- Excel: Hide Row Numbers and Column Letters in Sheets
- Excel: How to Hide Every Other Column in a Worksheet
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Filter Wildcards: What Works and HowGoogle Sheets’ basic filter conditions do not treat * or ? as wildcard characters: “Text contains” searches for…
- Google Sheets Merge Cells Shortcut and Safe AlternativesGoogle Sheets has no dedicated keyboard shortcut that directly merges selected cells. In a browser, select the cells…
- Unblock a Sender in Outlook 365: Step-by-StepTo unblock a sender in Outlook 365, remove their email address or domain from your blocked senders list.…
- Remove Duplicates Based on Two Columns in Excel: StepsTo remove duplicates based on two columns in Excel, select the entire data range, choose Data > Remove…
- Calculate Age in Excel Using an ID Number with a Birth DateIf an ID number begins with a date of birth, you can extract its year, month, and day…
- How to Delete a Page in Word on PCTo delete a page in Word on a PC, select the page’s contents with Go To and press…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.