Excel Slow? Causes, Fixes, and Ways to Speed It Up

How-to basics · Updated November 18, 2026

If Excel is slow, first find out whether the delay affects one workbook or every workbook, then check calculation settings, add-ins, and the workbook’s size. Close other demanding apps and save a copy before making major changes; the right fix depends on whether Excel is slow to open, calculate, scroll, or save.

Work out what is actually slow

Different symptoms point to different causes. A pause while opening Excel may involve add-ins or Office itself, while a delay after changing a cell often means formulas are recalculating. Slow scrolling or selecting cells can indicate a large, heavily formatted sheet, and slow saving may involve a large file, cloud synchronization, or a network location.

Start with a simple comparison: open a new blank workbook and try ordinary actions such as typing, scrolling, and saving. Then open another existing workbook, if available. If the blank workbook is responsive but one file is not, focus on that workbook. If Excel is slow everywhere, investigate add-ins, updates, system resources, or the Office installation.

  • Slow to start: check add-ins and whether the problem affects all workbooks.
  • Slow after edits: check formulas and calculation mode.
  • Slow to scroll or select: check used range, formatting, and objects.
  • Slow to save or refresh: check file location, size, external connections, and synchronization.

Try these quick checks first

Save your work, close other applications that use substantial memory or processing power, and restart Excel. If Excel is unresponsive, allow a little time before forcing it to close: a large calculation or data refresh can take a while. On Windows, Ctrl+Shift+Esc opens Task Manager, where you can see whether Excel is using substantial CPU or memory. On a Mac, check Activity Monitor in Applications > Utilities.

Next, check whether the workbook is stored on a network drive or in a folder synchronized by OneDrive. If the file is safe to copy, save a separate local copy and compare how quickly it opens and saves. Do not edit competing copies and then assume their changes will merge automatically. A local copy is a diagnostic test, not a reason to abandon the organization’s storage or backup rules.

Also make sure Excel and Windows are not in the middle of an update or another resource-intensive task. In Excel for Microsoft 365 on Windows, check File > Account > Update Options > Update Now. Updates can fix software problems, although they do not automatically cure a workbook whose formulas or data are inherently demanding.

Check formulas and calculation settings

When a cell edit triggers a long pause, calculation is a leading suspect. A workbook can contain many formulas, and some formulas depend on other cells that depend on still more cells. A change near the start of that chain may cause Excel to recalculate a large part of the workbook. Look for formulas copied far below the visible data, repeated calculations of the same intermediate result, and references to entire columns in expensive array calculations.

In Excel for Microsoft 365 on Windows, check Formulas > Calculation Options. In most workbooks, Automatic is the expected setting. If the workbook is set to Manual, formula results may not update after each edit; pressing F9 recalculates open workbooks, but it is not a permanent performance fix. A workbook saved in manual mode can also surprise someone who opens it later, so coordinate any change with other users.

Some functions recalculate whenever Excel recalculates, even when their inputs have not changed. Examples include NOW, TODAY, RAND, OFFSET, and INDIRECT. They can be useful, but hundreds or thousands of repeated instances may add noticeable work. Where practical, reduce unnecessary repetitions, calculate a shared intermediate result once, or replace a volatile approach with a suitable nonvolatile one. Do not change a formula simply for speed unless the replacement preserves the intended result.

Full-column references are convenient, but can be costly in complex formulas that process every cell in a column. If the data has a known extent, bounded references or an Excel table may limit unnecessary work. Tables also expand as new rows are added, which can make formulas easier to maintain. Test changes on a copy and verify representative results before using them in the original workbook.

Reduce oversized or cluttered worksheets

A sheet may look small while Excel treats a much larger area as used because cells far below or to the right contain old formatting, content, or other remnants. Press Ctrl+End on Windows to see the last cell Excel considers used. If it is far beyond the real data, inspect the intervening rows and columns before removing anything: they may contain formulas or notes you still need.

When you confirm that extra rows or columns are unnecessary, select them and use Home > Delete > Delete Sheet Rows or Home > Delete > Delete Sheet Columns. Save the workbook, close it, and reopen it so Excel can update the used range. Removing formatting with Clear is not always the same as deleting the extra rows or columns. Keep a backup, especially in shared or business-critical files.

Excessive conditional formatting, complicated borders, cell styles, merged cells, and floating pictures or shapes can also make a workbook slower to render or edit. Open Home > Conditional Formatting > Manage Rules and review whether rules are duplicated or applied to far more cells than necessary. Narrow a rule’s range only if that still covers the intended data. Avoid selecting an entire worksheet for formatting when the rule needs to cover only a defined table.

Large workbooks do not always need to be split. First remove genuinely unnecessary content, repeated formatting, and unused images. If a workbook contains huge volumes of imported records, consider whether the data belongs in a database or a purpose-built data model rather than hundreds of thousands of worksheet formulas.

Test add-ins without disrupting your workbook

An add-in can slow Excel during startup or interfere with particular actions. On Windows, use the Run dialog to start Excel in Safe Mode by entering excel /safe. Safe Mode starts Excel with many customizations and add-ins disabled. If Excel becomes responsive there, an add-in or customization is a reasonable lead; Safe Mode is a diagnostic step, not a setting to use for normal work.

To review add-ins, open File > Options > Add-ins. At the bottom, use the Manage list to select COM Add-ins and choose Go; you can also review Excel add-ins in that list. Disable one suspected add-in at a time, restart Excel, and compare behavior. This makes it easier to identify the cause than disabling several items at once. If an add-in is required by your workplace, ask its administrator before removing it.

Excel for Mac has different startup and settings interfaces, so the Windows excel /safe command and File > Options path do not apply there. Review available add-ins in Excel’s add-in management controls, and consult your organization’s support team if a managed add-in appears responsible.

Consider memory, file location, and data connections

Excel’s performance depends partly on available system resources. A computer running low on memory may slow down when several large applications and workbooks are open. Close files you do not need, and check whether the slowdown coincides with another demanding process. On Windows, 64-bit Office can address more memory than 32-bit Office, which can matter for large workbooks, but installing it is not a guaranteed speed boost for every file. Compatibility with older add-ins and other software should be checked first.

External links, queries, and data connections can make opening or refreshing a file appear slow, particularly if a source is unavailable or remote. If the delay occurs around a refresh, inspect Data > Queries & Connections and identify which query or connection is involved. Do not delete a connection merely to speed things up: it may supply data needed for reports. Ask the data owner about refresh schedules, source availability, and whether the workbook is intended to refresh automatically.

Saving in a different format is not a universal cure. The .xlsb format can produce a smaller file in some cases, but compare compatibility, sharing requirements, and features before converting. Keep an original copy and test the converted file. A smaller file may be quicker to transfer without making formulas or calculations faster.

When the problem affects every workbook

If a blank workbook and several existing files are all slow, focus on Excel or the computer rather than editing each workbook. Check for a recent change, such as a new add-in, Office update, printer driver, or security policy. If the issue began immediately after installing a particular add-in, disable it temporarily and contact its provider or your IT team.

On Windows, you can repair Microsoft 365 from Settings > Apps > Installed apps: select Microsoft 365, choose Modify, and try Quick Repair. The labels can vary slightly by Windows release and installation type. Save and close Office files first. If Quick Repair does not help, your organization’s support team can advise whether an online repair is appropriate, since it may take longer and require Office to be set up again.

For a work computer, avoid changing registry settings, security controls, or managed Office components based on an online tip. IT staff can check policies, network issues, and add-ins that are not visible to an ordinary user. If Excel repeatedly stops responding or crashes, note the affected files, the action that triggers it, and any error message; that information is more useful than a general report that Excel is slow.

Prevent slowdowns as workbooks grow

Good workbook design reduces avoidable work. Keep raw imported data separate from presentation where practical, avoid copying formulas and formatting far beyond the data, and use clear ranges or tables. Review conditional formatting and external connections when a workbook’s purpose changes. If a report needs many repeated calculations, calculate common intermediate values once rather than rebuilding the same work in many cells.

  • Keep a dated backup before restructuring an important workbook.
  • Use tables or appropriately bounded ranges rather than unnecessarily huge ranges in demanding calculations.
  • Remove only confirmed-unused rows, columns, rules, and objects.
  • Refresh external data deliberately and document where its source comes from.
  • Record whether a slowdown affects one file, one action, or all of Excel.

These practices do not guarantee instant performance: workbook size, formula complexity, computer capacity, and data-source response all matter. They do make the cause easier to isolate and reduce the chance that a quick cleanup will remove something the workbook relies on.

Frequently Asked Questions

Why is Excel slow when I type?
If each edit causes a pause, Excel may be recalculating dependent formulas, applying conditional formatting, or updating a connection. Check calculation settings and test a copy with the relevant formulas or connections isolated before changing the live file.

Why is Excel slow to open?
Startup add-ins, a large workbook, external links, and remote or synchronized file locations can all contribute. Compare a blank workbook, another file, and—if permitted—a local copy, then investigate the factor that changes the delay.

Does manual calculation make Excel faster?
It can reduce recalculation while you make many edits, but results will not update automatically after every change. It is a temporary workflow choice for some tasks, not a general fix; switch back to Automatic when appropriate and recalculate before relying on results.

Will adding more RAM fix a slow workbook?
Not necessarily. More memory may help when the computer is short of available memory, but it will not remove inefficient formulas, excessive formatting, or a slow external data source. Check system resource use and the workbook’s behavior before deciding.

Why is only one Excel file slow?
That file may have unusually complex formulas, excessive formatting, a bloated used range, embedded objects, or external connections. Compare it with a blank workbook, then inspect a copy of the affected file so cleanup does not accidentally remove needed content.

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.