Excel Very Slow? Common Causes and Practical Fixes

How-to basics · Updated November 21, 2026

Excel is often slow because it is recalculating a large or complex workbook, loading add-ins, or working with a file stored on a slow or busy network. First check whether every workbook is affected or only one; then test the workbook in Excel Safe Mode and on a local copy to narrow down the cause before changing formulas or settings.

Find out what is actually slow

Notice when the delay happens. A pause while opening a file points toward file size, external links, queries, or startup add-ins. A delay after editing a cell often indicates calculation or conditional formatting. Slow scrolling can instead come from many shapes, images, formatted cells, or a large displayed range. If Excel freezes only while saving, check the file location, sync status, and workbook size.

Compare the same action in a new blank workbook. If a blank workbook is responsive but one particular file is not, focus on that file. If all workbooks are slow, look at add-ins, Excel updates, other running programs, available memory, or the computer itself. The status bar at the bottom of Excel may say Calculating while formulas are being updated; that is a useful clue, but it does not identify the exact formula responsible.

  • Slow when typing or changing inputs: investigate formulas and calculation settings.
  • Slow only when opening or saving: investigate file size, links, network storage, and synchronization.
  • Slow in every workbook: investigate add-ins, Excel, and system resources.
  • Slow scrolling or selecting cells: investigate formatting, objects, and the used range.

Check formula recalculation

In Microsoft 365 for Windows, open Formulas > Calculation Options and check whether calculation is set to Automatic. Automatic calculation is the normal choice for most workbooks: Excel updates dependent formulas when their inputs change. A workbook with many formulas, complex lookups, or repeated calculations can take noticeable time to update.

Look for formulas that process far more cells than necessary. For example, applying an operation to an entire column in thousands of formulas can create much more work than limiting each formula to the rows that contain data. Large array calculations, deeply nested formulas, and formulas that repeatedly search the same data can also add to the workload. If a workbook contains many formulas that reference other formulas, the combined calculation chain may be costly even when no single formula looks especially complicated.

Some functions recalculate whenever Excel recalculates, even if their inputs have not changed. Common examples include NOW, TODAY, RAND, OFFSET, and INDIRECT. A workbook that uses these functions extensively may therefore feel slow after unrelated edits. Replace or reduce them only when the workbook’s intended behavior allows it; for instance, a timestamp that must remain fixed is not equivalent to a formula that always returns the current time.

Manual calculation can be a temporary way to make extensive editing easier, but it is not a general repair. With Manual selected, results can remain out of date until recalculation. Calculation mode can also affect other workbooks open in the same Excel session. If you use it, recalculate before relying on results, and restore Automatic when appropriate.

Reduce unnecessary workbook weight

A workbook may contain much more than the visible values. Formatting applied to entire rows or columns, old data left far below the working area, hidden sheets, images, charts, and copied objects all contribute to what Excel must manage. A worksheet can also have an inflated used range if cells far beyond the real data were formatted or edited in the past.

Press Ctrl+End on Windows to see the last cell Excel regards as used on the active worksheet. If it is far beyond the actual data, inspect the intervening area before removing anything. Delete only genuinely unused rows or columns, save the workbook, close it, and reopen it to see whether the used range has contracted. On Mac, the shortcut differs; use the equivalent Go To or navigation command available in that version, or inspect the sheet manually. Do not delete rows just because they look blank: they may contain formulas, formatting, or content needed later.

Excessive conditional formatting can also slow a sheet, especially when many overlapping rules apply to very large ranges. Select a representative area and use Home > Conditional Formatting > Manage Rules to review the rules that apply to the selection or worksheet. Remove duplicate or obsolete rules, and limit remaining rules to the cells that need them. Before removing formatting or content, save a copy so you can restore the original if the sheet depends on it.

If the file is unusually large, Save As can help you compare formats. The .xlsx format is a common choice for workbooks without macros. The .xlsb binary format can produce a smaller file in some cases, but it is not guaranteed to make every workbook faster and may be less convenient for systems that expect .xlsx. Test a copy and confirm that formulas, macros, and sharing requirements still work before switching formats.

Test add-ins and startup behavior

An add-in can affect Excel even when the workbook itself is modest. To test this on Windows, close Excel, press Windows key+R, type excel /safe, and press Enter. Safe Mode starts Excel with features such as add-ins and startup files bypassed. If the same task becomes much faster, an add-in or startup item is a likely cause. Safe Mode is a diagnostic test, not a permanent solution.

To isolate add-ins, open File > Options > Add-ins. At the bottom, choose COM Add-ins in the Manage list and select Go. Clear the check box for an add-in, restart Excel normally, and repeat the task. If needed, test Excel Add-ins separately using the same Manage area. Disable only items you can safely do without, and turn them back on one at a time to identify the one associated with the delay. Your organization may require particular add-ins, so check with its support team before removing them.

Menus vary on Mac, where Excel settings are under the Excel menu rather than Windows File > Options. Add-in availability and testing steps can differ by platform. If Safe Mode is unavailable in your setup, disabling add-ins through Excel’s settings and restarting is a practical alternative.

Check Excel and computer resources

When all workbooks are slow, check whether another application is using substantial processor time or memory. On Windows, Task Manager can show whether Excel is busy calculating or waiting while other programs consume resources. Close applications you do not need, but avoid ending processes whose purpose you do not recognize. Also make sure the computer has enough free storage for temporary files and normal operation.

Install available Microsoft 365 updates from File > Account > Update Options > Update Now on Windows. Updates can include fixes, though an update is not guaranteed to resolve a particular workbook’s performance problem. If Excel started slowing immediately after a change, note what changed and consult your organization’s support team if the computer is managed.

64-bit Excel can use more memory than 32-bit Excel, which may matter for very large workbooks or data models. Switching to 64-bit is not automatically a speed boost, and compatibility with older add-ins should be checked first. Similarly, a faster computer cannot always compensate for inefficient formulas or a workbook that repeatedly retrieves data from a slow source.

Look at file storage, links, and data refreshes

A workbook on a shared network drive, remote desktop, or synchronized folder may respond differently from a local file. For diagnosis, save a separate copy to a local folder and compare opening, editing, and saving times. Do not edit the local test copy and the shared original as if they were the same live file; their contents can diverge. A faster local copy suggests that network access, synchronization, permissions, or a shared service may be contributing to the delay.

External workbook links and data connections can slow opening or refreshing, particularly if a source is unavailable. In current Microsoft 365 for Windows, check Data > Workbook Links when that command is available. For queries and connections, use Data > Queries & Connections. Identify what each link or query supplies before changing it: removing a connection may break a report or prevent future updates. If a refresh takes a long time, compare the time spent retrieving data with the time spent calculating after it arrives.

Cloud storage is not inherently slow, and keeping a file synchronized can be valuable for collaboration and recovery. The useful question is whether the delay follows the workbook when it is tested locally. If other people use the file, coordinate tests and avoid disabling synchronization or changing sharing settings without understanding the effect.

Use a safe troubleshooting order

Make a backup before substantial edits. Then change one thing at a time and repeat the same action, such as opening the file or editing a particular input cell. Changing several settings at once makes it difficult to tell what helped and can introduce new problems.

  1. Compare a blank workbook with the affected workbook, and note whether the delay occurs during opening, editing, calculation, scrolling, refreshing, or saving.
  2. Open Excel in Safe Mode on Windows. If performance improves, test add-ins individually.
  3. Check calculation mode and watch for a Calculating message after edits. Inspect the most complex or frequently recalculated sheets first.
  4. Test a separate local copy if the original is stored on a network or synchronized location.
  5. Review oversized formatting ranges, conditional formatting, external links, and queries. Remove or revise only items whose purpose you understand.
  6. Update Microsoft 365 and retest. If the problem persists across files, contact your organization’s support team or Microsoft support with the relevant version and file-location details.

This sequence helps separate a workbook problem from a system or storage problem without immediately resorting to drastic changes. If a workbook contains business-critical calculations, validate key results after any edits that affect formulas, links, or data connections.

Prevent slowdowns in future workbooks

Keep formulas and formatting limited to the areas that need them, remove obsolete conditional-formatting rules, and avoid storing years of detail in a workbook if the task only needs a smaller working set. Use clear, bounded data ranges where practical, and avoid copying entire sheets with large amounts of unused formatting. These habits reduce unnecessary work without requiring you to replace a useful workbook design just for the sake of speed.

For recurring reports, separate raw imported data from summary calculations and refresh only the sources that need updating. Keep a clean backup before making structural changes, and record which add-ins or external connections a workbook requires. If several people edit a file, agree on where the authoritative copy lives and how refreshes and links are managed. These simple practices make later troubleshooting more predictable.

Frequently Asked Questions

Why is Excel slow when I type? Excel may be recalculating dependent formulas after each change, especially if the workbook uses many complex or volatile formulas. Check the status bar and calculation mode, then investigate formulas and conditional formatting on the affected sheet.

Why is only one Excel file slow? That file may contain more formulas, formatting, objects, links, or data connections than other workbooks. Compare it with a blank workbook and test a copy locally to distinguish workbook complexity from network or synchronization delays.

Will switching Excel to Manual calculation fix the problem? It can reduce repeated recalculation while you edit, but it does not make the formulas themselves more efficient. Results can be stale until recalculated, and the mode may affect other open workbooks, so treat it as a temporary, deliberate setting.

Does a larger computer always make Excel faster? No. More memory or a faster processor can help when system resources are the bottleneck, but they will not necessarily fix a slow network connection, a problematic add-in, or inefficient workbook design.

Is it safe to disable Excel add-ins? It is reasonable to disable an add-in temporarily for diagnosis, then re-enable it if needed. Some add-ins provide required workplace features, so check their purpose and consult your organization before removing or permanently disabling them.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.