Why Is Excel So Slow? Two Root Causes (and How to Fix Each)

You click a cell. Nothing happens for two seconds. You apply a filter and watch the screen freeze. "Not Responding" appears in the title bar, and you start wondering if you saved.

Excel slowness falls into two distinct categories. One is fixable with settings changes and file cleanup. The other is structural — your data has outgrown what Excel was designed to handle. Most troubleshooting guides mix these together, which is why people try ten fixes and still end up staring at a frozen screen.

Figure out which kind of slow you're dealing with, and you'll get to the solution faster.

Quick wins: settings-level fixes

Before changing individual settings, start with one diagnostic step.

Use Safe Mode to isolate the cause

If Excel feels slow, launch it in Safe Mode first to narrow down the cause in one step.

Safe Mode starts Excel without loading any add-ins, custom toolbars, or startup files. If the problem disappears in Safe Mode, you know the culprit is an add-in or configuration file — not Excel itself. If the problem persists in Safe Mode, add-ins are not the culprit — focus on file-level issues instead.

Press Win + R, type excel /safe, and hit Enter. Or hold Ctrl while clicking the Excel icon. The title bar will show "Safe Mode" when it's active.

If Safe Mode runs smoothly, proceed to the add-in cleanup step below. If it's still slow, jump straight to the "File-level fixes" section — you'll save time by skipping add-in troubleshooting entirely.

Disable hardware graphics acceleration

If cell navigation and scrolling are slow even in a blank workbook, the GPU rendering setting is the most likely cause.

Excel offloads screen rendering to your GPU by default. When the GPU driver and Excel don't get along, every screen redraw triggers a delay. This problem is unrelated to file contents, so it affects every workbook uniformly.

Go to File → Options → Advanced → Display, then check "Disable hardware graphics acceleration." Restart Excel.

Whether this fixes the issue tells you immediately if the slowness is GPU-related. If it doesn't help, uncheck the box and move on.

Audit and remove COM add-ins

If Excel takes a long time to start up, suspect add-ins that load in the background.

Add-ins are loaded every time Excel launches and consume memory continuously. COM add-ins in particular run inside Excel's own process, so a single problematic one can drag down overall performance.

File → Options → Add-ins → Manage (select "COM Add-ins") → Go. Uncheck anything you can't explain the purpose of.

If you're not sure which add-in is the problem, uncheck all of them, restart Excel, and re-enable them one at a time. The one that brings back the lag is your culprit.

Switch calculation mode to manual

If Excel freezes every time you type a value into a cell, turning off automatic calculation provides immediate relief.

By default, Excel recalculates every formula in the workbook each time you edit a single cell. In workbooks with thousands of formulas, typing one character triggers a cascade of recalculations that locks up the interface.

Formulas → Calculation Options → Manual. Recalculation now only runs when you press F9.

When using manual calculation, always press F9 before relying on any computed values. If others use the same file, let them know about the change to avoid errors.

Adjust AutoSave and AutoRecover intervals

If Excel hiccups every few minutes with a brief freeze, AutoSave intervals are probably the cause.

In Microsoft 365, AutoSave can trigger frequently. Each save operation takes time proportional to file size, so larger workbooks produce more noticeable pauses at regular intervals.

File → Options → Save. Extend the AutoRecover interval to 20–30 minutes, or disable it temporarily for intensive work sessions. At the bottom of the same screen, click "Delete Cached Files" to clear accumulated temporary data.

If you turn off AutoSave, build a habit of saving manually (Ctrl + S) at natural breakpoints. Even just extending the interval — rather than disabling it entirely — can noticeably reduce the interruptions.

Check your default printer

If only Excel has suddenly become slow while other Office apps run fine, check your printer configuration.

Excel queries the default printer every time it opens a file to set up page layout and print areas. When the default printer is a network printer that isn't responding, or has an outdated driver, file opening and page rendering slow to a crawl. Files saved in Page Break Preview mode are especially affected.

Open Windows Settings → Bluetooth & devices → Printers & scanners, and switch the default printer to "Microsoft Print to PDF" or another lightweight local option.

If switching the printer fixes the issue, update the driver for your original network printer before switching back — that often resolves the root cause.

File-level fixes that remove hidden drag

If the settings above didn't help, the problem lives inside your file. Workbooks accumulate invisible weight over months and years of edits, copy-pastes, and formula additions.

Find and delete invisible objects and ghost rows

If only one specific workbook is slow, start by checking for invisible objects and ghost rows.

Copy-paste operations sometimes duplicate transparent shapes, text boxes, and comment markers without any visual indication. Meanwhile, "ghost rows" — empty cells that Excel still treats as part of the used range — inflate file size and slow down rendering.

For objects: Home → Find & Select → Selection Pane. This lists every object on the active sheet. Delete anything you don't recognize. For ghost rows: press Ctrl + End. If the cursor lands far beyond your actual data, select the empty rows and columns between your data and that point, delete them, and save.

These two cleanups alone can cut file size in half. Consider running them regularly — for example, as part of your month-end close process — to prevent gradual bloat.

Scope down conditional formatting rules

Check your conditional formatting ranges. Formatting applied to entire columns will slow Excel down on its own.

Setting conditional formatting on A:A forces Excel to evaluate rules across over a million cells, most of them empty. Conditional formatting is useful for visual feedback, but the rendering cost scales directly with the size of the formatted range.

Home → Conditional Formatting → Manage Rules → select "This Worksheet." Look for rules with ranges like A:A or 1:1048576 — those are the ones causing the drag.

Narrow the range to your actual data (e.g. A2:A5000), or convert your data to an Excel Table so rules auto-adjust as rows are added. Tables offer benefits beyond conditional formatting, so if you haven't tried them yet, this is a good time to start.

Replace volatile functions (OFFSET, TODAY, NOW)

If your workbook uses OFFSET, TODAY, NOW, INDIRECT, or RAND heavily, reducing them will speed things up.

These are "volatile functions" — they recalculate every time any cell in the workbook changes, not just when their own inputs change. Normal functions only recalculate when their references update, but volatile functions trigger full recalculation every time. Spread across thousands of rows, the cumulative cost is severe.

Replace OFFSET with INDEX. Replace INDIRECT with direct cell references where possible. For TODAY, consider entering the date as a static value or using a VBA macro that runs once on file open.

Start by pressing Ctrl + F and searching for OFFSET or INDIRECT across the workbook to gauge the scale. If there are only a few, replace them manually. If there are hundreds, switch to manual calculation first and tackle them in stages.

Convert finished formulas to static values

If cells contain formulas whose results will never change, convert them to values. Every formula you remove is one fewer recalculation.

Excel re-evaluates all formulas during each recalculation cycle, including ones whose results haven't changed. Last month's report and finalized summaries don't need to be recalculated, but if the formulas are still there, they add to the cost every time.

Select the cells, copy, then Paste Special → Values (Ctrl + Shift + V → Values). The displayed numbers stay the same, but the formula bar now shows a static value instead of a calculation.

Adopt a rule: "past data gets converted to values, only current data keeps formulas." If you convert the previous month's sheet to values as part of your regular workflow, the workbook's recalculation load gets lighter month after month.

Remove unused macros and VBA code

If unused macros or VBA modules are sitting in your workbook, deleting them reduces both file size and load time.

Macros and VBA code are loaded and parsed every time the file opens, even if they're never executed. Empty modules and orphaned UserForms still contribute to file bloat and startup overhead.

View → Macros → View Macros to check for unused macros. Open the VBA Editor (Alt + F11) to find empty modules or unused UserForms.

If you're unsure whether a macro is still needed, make a copy of the workbook, delete the macros from the copy, and use it for a week to confirm nothing breaks.

Compress images inside the workbook

If your workbook contains many images, compressing them alone can dramatically reduce file size and improve performance.

Product photos and screenshots are stored at their original resolution inside the Excel file. Even if you've resized them visually on the sheet, the underlying data remains full-size. A handful of high-resolution images can push file size into the tens of megabytes.

Click any image → Picture Format tab → Compress Pictures. Set resolution to "E-mail (96 ppi)" or "Web (150 ppi)." Uncheck "Apply only to this picture" to compress all images in the workbook at once.

Going forward, resize images in a separate tool before inserting them into Excel. This prevents file bloat from the start rather than cleaning it up after the fact.

Clean up external links and references

If a file takes several minutes just to open, cleaning up external links is often the most effective fix.

Formulas that reference other workbooks or network files cause Excel to check those sources every time the file opens. If the referenced file has been moved or deleted, or if you're on a slow VPN, the wait for a response alone can take minutes.

Data → Edit Links. Review the list and break any links you no longer need — this converts them to static values.

For links you do need to keep, open the source files first before opening the dependent workbook to avoid response timeouts. Also check periodically that the file paths haven't changed.

Convert legacy .xls files to .xlsx

If you're still using .xls files, converting to .xlsx will make them faster immediately.

The .xls format dates back to Excel 2003. Modern Excel opens these files in compatibility mode, which disables current optimizations and slows down both calculation and rendering.

File → Save As → change the file type to .xlsx (or .xlsm if the file contains macros).

If your organization has many .xls files, schedule a batch conversion session by team or department. The conversion itself takes seconds per file and typically reduces file size substantially.

Try .xlsb (binary) format for large workbooks

For workbooks with large datasets, switching the save format to .xlsb speeds up both reading and writing.

The .xlsb (binary workbook) format has a more compact internal structure than standard .xlsx (which is XML-based). File sizes shrink, and load/save operations become noticeably faster for workbooks with tens of thousands of rows or more. Macros are preserved.

File → Save As → change file type to "Excel Binary Workbook (*.xlsb)."

Use .xlsb for internal workbooks you open repeatedly, and keep .xlsx for files you share externally. This gives you the performance benefit where it matters most without compatibility concerns.

When settings won't help — Excel's structural ceiling

If you've tried everything above and Excel is still slow, the problem isn't settings or file hygiene. It's the volume of data itself. This is Excel by design, and no settings change will fix it.

The 1-million-row wall and how recalculation works

Excel worksheets max out at 1,048,576 rows, and the practical comfort zone is well below that number.

"Supports up to 1 million rows" and "runs well at 1 million rows" are not the same claim. Excel recalculates all dependent formulas on every cell change. This architecture works brilliantly for budgets and financial models with a few thousand rows, but it was never designed for aggregate analysis of large datasets.

In practice, filter and sort operations start lagging noticeably beyond 50,000 rows. VLOOKUP formulas referencing a 500,000-row table can take minutes to recalculate. VLOOKUP formulas referencing a 500,000-row table can take minutes to recalculate, because each lookup scans the table linearly (unless you're on Microsoft 365, which indexes lookup columns).

If you regularly work with datasets above 50,000 rows, consider the Power Query and external tool options covered later in this article.

The 32-bit memory ceiling

If Excel frequently freezes when you have multiple large files open, check whether you're running the 32-bit version.

The 32-bit version of Excel is limited to 4 GB of RAM maximum, shared between Excel itself, add-ins, and all open workbooks. Opening several large files at once can push past this limit, causing severe slowdowns.

To check: File → Account → About Excel. The dialog will show either "32-bit" or "64-bit."

If you're on 32-bit and struggling with large data, switch to 64-bit. With Microsoft 365, uninstall Office and reinstall selecting the 64-bit option.

Why "large data" slowness is a different problem entirely

If every optimization in this article has been applied and Excel is still slow, the issue is Excel's ceiling — not something you can tune away.

Settings changes eliminate wasted overhead, but the computational cost inherent to your data volume remains. A VLOOKUP across 100,000 rows is a 100,000-row lookup no matter how many add-ins you've disabled or how much conditional formatting you've removed.

If you've switched to manual calculation, eliminated volatile functions, compressed images — and you're still waiting 30+ seconds — that's the best performance Excel can deliver for your data size.

Move to Power Query or a browser-based tool built for larger data. At this point, continuing to use Excel is itself the bottleneck.

Repair the Office installation

If nothing has worked — settings, file cleanup, and even Safe Mode didn't help — try repairing the Office installation.

Damaged Office program files can degrade overall performance even when settings and files are clean. Windows Updates or past crashes can corrupt files without the user noticing.

Control Panel → Programs and Features → find Microsoft Office → Change → Online Repair. This re-downloads and reinstates program files without affecting your settings or documents. It takes 30–60 minutes.

Think of this as the last resort. When every other step has failed and the slowness remains unexplained, a repair installation has resolved the issue in cases where nothing else could.

Options for working with data beyond Excel's comfort zone

Several approaches exist for handling large datasets without learning to code.

Use Power Query to filter before loading

If you need to work with large data inside Excel, Power Query should be your first consideration.

Power Query is built into Excel and lets you filter, transform, and aggregate data before it reaches the worksheet. By loading only the rows and columns you actually need, you drastically reduce the amount of data Excel has to manage.

Data → Get Data → From Text/CSV. Select your file, then click "Transform Data" instead of "Load." The Power Query editor lets you remove columns, filter rows, change data types, and aggregate — then output just the results to a worksheet.

Power Query's interface is different from standard Excel, so there's a learning curve. Start with something simple — open a CSV and remove unneeded columns — to get comfortable before tackling more complex transformations.

Browser-based tools as an alternative

If Power Query feels too complex, browser-based CSV tools offer a more familiar interface without Excel's row limits.

Services like Gigasheet, Datablist, and Row Zero can handle millions of rows with spreadsheet-like filtering, sorting, and pivot operations. The experience is closer to Excel than to a code editor.

Gigasheet, for example, lets you upload multi-million-row CSVs and apply filters, grouping, and pivot summaries — without hitting Excel's or Google Sheets' row limits.

One important caveat: most of these services upload your data to their servers. For internal revenue data, customer records, or anything covered by data policies, consider a local-processing tool like the one below.

LeapRows (disclosure: built by the author) for local CSV analysis

If you need to process large CSVs with sensitive data, a local-processing tool that keeps your data inside the browser is the right fit.

LeapRows (disclosure: built by the author) is a browser-based tool for opening, filtering, pivoting, and converting CSV files. It uses DuckDB-WASM to run all processing locally on your machine — no server upload, no cloud dependency. Your data never leaves the browser.

Pivot operations that take minutes in Excel can complete in seconds. The interface is closer to Excel's filter-and-click workflow than to a code editor, and no programming is required.

If you've hit Excel's speed limits but can't upload data to external servers, give it a try.

Diagnosis checklist: which kind of "slow" do you have?

Quick diagnosis table

The first group responds to the fixes in this article. The second category calls for moving