If Excel is very slow or shows Not Responding, first give it a short time to finish a calculation or file operation; if it stays stuck, close other demanding apps, reopen Excel, and test whether the problem affects one workbook or every workbook. That distinction helps identify whether the cause is a particular file, an add-in, Excel itself, or the computer or network.
What Not Responding means
In Windows, Not Responding means Excel is not currently answering the operating system’s requests. It does not prove that Excel has crashed: the program may be busy recalculating formulas, loading data, saving a large file, or waiting for a network location. A busy workbook can recover if you let the operation finish. Repeatedly clicking the window or starting extra copies of Excel can make the wait worse.
If the status persists and there is no sign of activity, you may have to close Excel. Unsaved changes can be lost when you force an app to quit, so use that as a last resort. If Windows offers to wait or close the program, wait briefly when Excel has just begun a demanding operation. If you must end it, reopen Excel and look for Document Recovery; recovered versions are not guaranteed to contain every recent change.
Try these checks first
Start with simple checks that do not change the workbook. Note whether the problem began after an Office update, a new add-in, a file move, or a change to the workbook. Then use this sequence:
- Wait a minute or two after a large calculation, refresh, save, or import. Avoid clicking repeatedly while Excel is busy.
- Check whether other applications are also slow. Close apps and browser tabs you do not need, and make sure the computer has available storage and memory.
- Restart Excel. If Excel will not close normally, save work in other apps and use Windows Task Manager to end the Excel task only when necessary.
- Open a new blank workbook. If it works normally, test the troublesome workbook separately. If even a blank workbook is slow, investigate Excel, add-ins, updates, and the computer.
- Make a copy of the affected file before attempting repairs or removing content.
For a file on a shared drive or cloud service, test a local copy if your organization’s rules allow it. If the local copy behaves normally, the delay may involve the connection, synchronization, permissions, or remote storage rather than Excel’s calculation engine.
Find out whether one workbook or all workbooks are affected
This is one of the most useful ways to narrow the cause. If only one workbook is slow, inspect its formulas, formatting, external connections, and size. A file can become sluggish even when it does not look large: sheets may contain formatting far beyond the visible data, many shapes or charts, or formulas that repeatedly process large ranges.
If all workbooks are slow, look beyond that file. Common possibilities include an Excel add-in, an Office installation problem, an outdated build, limited system resources, or a printer or network dependency. Try a blank workbook and, if possible, another user account or another computer. Comparing results can show whether the issue follows the file or stays with the computer.
Also check the taskbar for multiple Excel windows and consider whether other workbooks are open in the background. A large calculation or data refresh in one workbook can make another appear unresponsive because Excel is sharing the computer’s resources.
Test Excel without add-ins
An add-in can affect startup, workbook opening, calculations, and interactions with other programs. On Windows, close Excel, press Windows key+R, type excel /safe, and press Enter. Safe Mode starts Excel with certain features and add-ins bypassed. Open the same workbook and compare its behavior. If it is noticeably faster, an add-in or startup customization is a reasonable suspect, though Safe Mode alone does not identify which one.
To check COM add-ins in normal Excel for Microsoft 365 on Windows, go to File > Options > Add-ins. At the bottom, next to Manage, select COM Add-ins and choose Go. Clear the check box for an add-in, restart Excel, and test again. Re-enable add-ins one at a time to find a possible cause. For Excel add-ins, select Excel Add-ins in the Manage list instead. Only disable add-ins you recognize or are permitted to change, especially on a managed work computer.
Excel for Mac does not use the Windows excel /safe command or the same COM Add-ins controls. Review available add-ins through Excel’s Tools menu and check with your organization’s support team if an add-in is managed centrally. Menu labels can differ by version. Do not delete add-in files just to test performance.
Check formulas, data, and formatting
Large or inefficient calculations are a frequent reason a workbook seems frozen. For example, formulas copied down hundreds of thousands of rows, repeated lookups across entire columns, or chains of formulas that depend on one another can take time to recalculate. Volatile functions such as NOW, TODAY, RAND, and OFFSET can trigger recalculation more often than expected. External links and formulas that depend on unavailable files can also delay opening or updating.
- Look for formulas copied far below the actual data, and remove genuinely unused rows or columns after making a backup.
- Review conditional formatting rules, especially rules applied to entire columns or overlapping ranges. Use Home > Conditional Formatting > Manage Rules to inspect them.
- Check for unnecessary images, shapes, charts, and duplicated formatting. If the file contains many objects, remove only items you can identify as unneeded.
- Review external links and data connections. Refresh only when you need current data, and verify that referenced files or sources are available.
- For repeated imports or cleanup tasks, consider using Power Query rather than manually repeating steps. For data too large to handle comfortably on a worksheet, a database or Excel’s Data Model may be more appropriate.
Excel’s used range can sometimes extend beyond the cells that contain meaningful data because of old formatting or edits. Press Ctrl+End on Windows to see the last cell Excel considers used. If it is far beyond the real data, first save a copy; then remove unnecessary rows or columns beyond the true end, save, close, and reopen the workbook. Do not delete cells that contain formulas, notes, or data needed by other sheets.
Review calculation settings carefully
Excel normally calculates formulas automatically. If a workbook has many formulas, recalculation may take time after edits or when the file opens. You can check the setting on the Formulas tab under Calculation Options. If it is set to Manual, formulas may not update until you request a calculation, which can make displayed results stale.
Manual calculation is not a general cure for a slow workbook. It changes when formula results are refreshed, so a displayed number may no longer reflect the latest inputs. If you use it temporarily for a large model, make the setting and its consequences clear to anyone using the file, then return to Automatic when appropriate. On Mac, calculation settings are also available from the Formulas tab, though the exact interface may vary with the Excel version.
When a calculation appears stuck, wait before interrupting it, particularly after changing a formula used throughout the workbook. If the file is important, work on a copy while investigating. Excel’s calculation chain and dependencies can make the time needed vary considerably between workbooks, so there is no single formula count that guarantees fast performance.
Check memory, updates, and network dependencies
Excel shares system memory and processing capacity with Windows and other applications. Very large workbooks, multiple open files, browser tabs, video calls, or background data tasks can leave fewer resources available. Restarting the computer can clear a temporary resource problem; it will not fix an inefficient workbook or a persistent add-in conflict. A 64-bit edition of Office can address more memory than a 32-bit edition, but it is not an automatic speed upgrade for every file. Check with IT before changing Office architecture on a managed device.
Install available Microsoft 365 updates when practical: in Excel, go to File > Account > Update Options > Update Now. Save your work first, and follow workplace update policies. If a workbook is on OneDrive, SharePoint, a VPN, or a network share, check whether synchronization or connectivity is paused or showing errors. Avoid editing conflicting copies while a file is syncing; wait for synchronization to settle or coordinate with the file owner.
Printing can also expose a dependency: Excel may communicate with the selected printer while laying out or previewing a sheet. If delays occur around printing, check that the selected printer is reachable and try a different available printer. Do not disable security software as a routine troubleshooting step. If you suspect it is interfering, ask your IT administrator to assess the situation safely.
Repair Office or recover a troublesome file
If all workbooks remain slow after checking add-ins and updates, repair Microsoft 365. In Windows 11, open Settings > Apps > Installed apps, find Microsoft 365, select the three-dot menu, and choose Modify. Quick Repair is the shorter first option; if it does not help, Online Repair is a more thorough repair that may require an internet connection and sign-in afterward. Save and close Office files first. The exact wording can vary by Windows release or installation type, and a work-managed device may require IT support.
If one workbook is the only problem, try opening a copy with Excel’s repair option. In Excel, choose File > Open > Browse, select the file, open the arrow beside the Open button, and choose Open and Repair. Follow the prompts and save any repaired result under a new name so the original remains available. Repair may recover a file, but it can also leave out damaged content; keep a separate backup.
Excel for the web can be a useful comparison for supported workbooks, particularly when the desktop app is the suspected source of a problem. It does not support every desktop feature or workflow, so a workbook that relies on certain add-ins, connections, or advanced features may behave differently. Treat it as a diagnostic alternative, not proof that the desktop file is defective.
Frequently Asked Questions
Should I wait when Excel says Not Responding?
Usually, wait briefly if Excel has just started calculating, saving, opening a large file, or refreshing data. If it remains unresponsive for a long time and does not recover, close it only when necessary; unsaved changes may be lost.
Why is Excel slow with one file but not others?
The workbook may contain extensive formulas, formatting, conditional formatting, objects, external links, or data connections. Test a copy, inspect those features, and compare it with a blank workbook to keep the investigation focused.
Will changing calculation to Manual make Excel faster?
It can postpone recalculation, but it does not remove the underlying work. Formula results can become outdated until recalculation runs, so use Manual only when you understand the consequences and can restore Automatic calculation.
Can an add-in make Excel stop responding?
Yes. Testing the workbook in Windows Safe Mode can help determine whether an add-in or startup customization is involved. If performance improves, disable add-ins one at a time through Excel’s Add-ins settings and retest.
How can I prevent losing work if Excel freezes?
Save important work regularly, keep a separate backup of critical workbooks, and avoid force-closing Excel unless it does not recover. After reopening, check Document Recovery and verify the recovered file before replacing the original.
Related
- Excel Split Cell Into Multiple Cells: Methods That Work
- Excel Split Names in One Cell Into Two Cells
- Excel Split One Cell Into Multiple Rows: How It Works
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Highlight the Largest Number in ExcelTo highlight the largest number in an Excel range, select the cells, choose Home > Conditional Formatting >…
- How to Combine Cells in Excel Into One Cell EasilyTo combine the contents of Excel cells into a new cell, join them with the ampersand operator (&)…
- Excel AutoSum Shortcut: How to Use Alt+=In Excel for Microsoft 365 on Windows, the AutoSum shortcut is Alt+=: select the blank cell where you…
- Excel Column Number Reference: Letters and NumbersIn Excel, columns have both letter references and number positions: A is 1, Z is 26, AA is…
- Vendor Comparison Sheet Excel Template: What to IncludeA practical vendor comparison sheet in Excel puts each supplier in its own column, lists decision criteria in…
- Company PowerPoint Template: Build a Reusable DeckTo create a company PowerPoint template, set up the brand colors, fonts, and reusable slide layouts in Slide…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.