Excel Not Responding Every Few Seconds? Fix the Pauses

Errors & fixes · Updated November 21, 2026

If Excel stops responding for a few seconds at regular intervals, first save a copy of the workbook if you can, then check whether the pauses happen in every workbook or only one. A workbook that freezes during calculation points to different causes than Excel that pauses even when idle; testing Safe Mode, add-ins, calculations, and file location can narrow it down without immediately reinstalling Office.

What repeated pauses usually mean

Excel may display Not Responding when Windows is waiting for Excel to finish work and the interface cannot accept input. A brief pause is not necessarily a crash: the program may recover once it completes a calculation, refreshes data, or waits for a file or add-in. If it never recovers, or the workbook closes, that is a more serious failure.

The timing and scope are useful clues. Pauses after typing or changing a cell often involve recalculation. Pauses while switching sheets, saving, or scrolling can involve a large workbook, graphics, or file access. A pause every few seconds even in a blank workbook suggests looking beyond that file, including add-ins, Office updates, or system resource pressure.

Before troubleshooting, note what you were doing just before a pause, whether the status bar shows Calculating or Refreshing, and whether other programs slow down at the same time. If Excel becomes responsive, save normally. If it is still stuck, give it a little time before ending the task; force-closing can lose changes made since the last save.

Check whether the problem is workbook-specific

Open a new blank workbook and leave it open for a few minutes. If the blank file remains responsive but one particular workbook stalls, focus on that workbook. If both pause, test Excel itself and the Windows environment. You can also open a second, small workbook while the problem file is closed, which helps distinguish a file issue from a general application issue.

Make a duplicate of the affected workbook before removing content or changing its structure. In the duplicate, test a smaller range or temporarily remove a sheet only if you understand its dependencies. A workbook with many formulas, conditional formatting rules, shapes, pivot tables, or extensive used ranges can be slow even when the visible data looks modest. Formatting far below or to the right of the actual data can also make a worksheet’s used area much larger than expected.

Check whether the file is stored locally or on a network drive, SharePoint, or OneDrive. If you have permission, save a separate copy to a local folder and test that copy. A local copy responding normally suggests that synchronization, network access, or a connection to the original location may be contributing, though it does not prove the network is the only cause.

Test add-ins in Excel Safe Mode

An add-in can run code or interact with workbooks, and a problem with one may cause recurring delays. On Windows, close Excel, press Windows key+R, type excel /safe, and press Enter. Safe Mode starts Excel with many customizations and add-ins disabled. If the pauses stop there, an add-in or customization becomes a reasonable suspect; Safe Mode is a diagnostic test, not a permanent fix.

To check add-ins in normal Excel, use File > Options > Add-ins. At the bottom, select COM Add-ins beside Manage and choose Go. Clear the check box for an add-in to disable it, then restart Excel and test. You can also select Excel Add-ins in the Manage list and choose Go to review that category. Disable one at a time, rather than all at once, so you can identify which change matters. Re-enable items you need and check with the add-in publisher for an update if one is implicated.

If Safe Mode also pauses, that does not rule out every add-in or cause. Continue with a blank workbook, calculation, file-location, and system-resource checks rather than assuming Office must be reinstalled.

Look for repeated recalculation

Excel recalculates formulas when relevant inputs change, and some formulas recalculate more often than ordinary formulas. Functions such as NOW, TODAY, RAND, OFFSET, and INDIRECT are volatile: they recalculate whenever Excel recalculates. A large number of these formulas, or formulas that refer to entire columns unnecessarily, can make frequent calculation work noticeable. Data tables, array calculations, and long chains of dependent formulas can add to the load.

Notice whether the status bar says Calculating during a pause. As a diagnostic, choose Formulas > Calculation Options > Manual. This changes calculation behavior, so formula results may remain out of date until you calculate; do not treat displayed results as current while manual mode is on. Press F9 to recalculate. If the pauses ease, investigate formula design and workbook size, then return to Formulas > Calculation Options > Automatic when finished. Calculation mode can affect other open workbooks, so verify the setting afterward.

For example, a workbook that calculates a lookup across a very large range in thousands of rows may take longer than one using a range limited to the actual data. Reduce unnecessary formula ranges, avoid repeating expensive calculations where a helper column can serve, and consider whether volatile formulas are needed. Change one thing at a time and compare responsiveness so you do not remove functionality without evidence.

Check data connections, links, and refreshes

External data can make Excel wait for a source or repeatedly perform work when a workbook opens or refreshes. Look for queries and connections under Data > Queries & Connections. Review whether a query is configured to refresh on opening or at an interval, and whether its source is reachable. Refreshing a large query can be expected to take time; repeated pauses when no refresh is expected deserve investigation.

Links to other workbooks may also prompt updates or depend on files that have moved or are unavailable. If Excel asks whether to update links, take note of the message rather than blindly choosing an option. Use Data > Workbook Links when available to review links in the workbook; the exact controls can vary with the workbook and Excel build. A link is not automatically harmful, but broken paths or many linked files can complicate opening and updating.

Do not delete queries, connections, or links just to test speed in your only copy. Some workbooks rely on them for reports. Duplicate the file first, and confirm with its owner before changing shared or business-critical data sources.

Consider cloud storage and AutoSave

For a workbook on OneDrive or SharePoint, synchronization and co-authoring may be part of the picture. Check whether Excel shows a saving or upload status when a pause occurs, and whether the connection is stable. If appropriate, test a separate local copy; avoid creating conflicting edits by working on both the local and shared versions at once. AutoSave is designed for supported cloud-stored files, but it does not explain every recurring freeze.

Also check whether the workbook is being edited by other people or whether another process is synchronizing or scanning its folder. A network interruption can make access to a shared file slower even though Excel itself is running normally. Ask whether colleagues see the same delay in the same workbook: shared symptoms point toward the file or its location, while a problem isolated to one computer points toward its local Excel setup or resources.

Update Office and check system resources

Install available Microsoft 365 updates after saving your work. In Excel, go to File > Account > Update Options > Update Now. Organizations may manage updates centrally, so the option or timing can differ on a work computer. Restart Windows after an update if prompted, and test again before making several other changes at once.

When a pause happens, open Task Manager with Ctrl+Shift+Esc and look at CPU, Memory, and Disk usage. If one is near its limit, identify whether Excel or another program is using the resource. Many large workbooks, browser tabs, background scans, or other demanding applications can compete for memory and processing time. Close only applications you recognize and can safely stop; do not end unfamiliar system processes.

If the issue persists across blank workbooks and Safe Mode, restart the computer and check that Windows and Microsoft 365 are up to date. On Windows 11, repair options are generally under Settings > Apps > Installed apps; on Windows 10, use Settings > Apps > Apps & features. Select Microsoft 365, choose Modify, and try Quick Repair first. Online Repair is more extensive and may require an internet connection and sign-in afterward. Organization-managed devices may require IT support.

When to escalate or use another route

If only one workbook remains slow after these checks, ask its creator or administrator whether it contains macros, external connections, or a known large calculation workload. If every workbook is affected, including in Safe Mode, and resource use is not obviously high, Microsoft 365 repair or help from your organization’s support team is more appropriate than repeatedly changing workbook content.

For a file stored in OneDrive or SharePoint, Excel for the web can sometimes help compare behavior, provided the workbook’s features are supported there. It is not a complete replacement for desktop Excel: some features and workflows differ, so use it as a comparison rather than assuming the workbook will behave identically. Keep an untouched backup before attempting repair or conversion.

Frequently Asked Questions

Why does Excel freeze every few seconds but then recover?
Excel may be completing calculations, refreshing a connection, saving or synchronizing a file, or waiting on an add-in. The activity at the moment of each pause, plus whether a blank workbook behaves the same way, helps identify which explanation is more likely.

Will ending Excel in Task Manager damage my workbook?
It can discard unsaved changes, so use it only when Excel does not recover and you have waited long enough to be confident it is stuck. After reopening Excel, check for Document Recovery or an AutoRecover version, but do not assume every recent change will be recoverable.

Does switching calculation to Manual fix the workbook?
It can reduce pauses caused by repeated calculation, but it does not repair the underlying formulas or update results automatically. Treat it as a test, verify that results are current when needed, and restore Automatic calculation unless you deliberately manage recalculation.

Why is Excel slow only with one file?
That workbook may have complex formulas, oversized used ranges, conditional formatting, links, queries, or other features that require extra work. Test a copy and compare it with a blank workbook; do not remove workbook components until you know what they do.

Should I reinstall Microsoft 365 right away?
Usually not. First test a blank workbook and Safe Mode, check calculation and file location, and install updates. If the problem continues across workbooks, Windows repair options or your IT support team are sensible next steps.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.