Slow Excel Files? 12 Ways to Optimize and Speed Up a Workbook

Slow Excel files are one of the most frustrating parts of working with large workbooks, and these 12 tips will help you speed them up. If you have worked with a big workbook, you have probably watched it slow down or stop responding. Excel is powerful, but as you add more data, complex formulas, and more sheets, it can start to drag. Fortunately, there are practical strategies that improve performance and keep your files running efficiently.

This guide walks through each tip with the exact steps, then includes a free workbook speed audit that tells you which fixes will help your file the most.

Why Is My Excel File So Slow?

Excel usually slows down for one of five reasons. Too many formulas recalculate every time you type, often because the workbook is set to automatic calculation and is full of volatile functions like OFFSET, INDIRECT, and TODAY. Formulas point at far more cells than they need, such as whole columns inside array formulas. Formatting and conditional formatting rules stretch across entire rows and columns. Images, shapes, and unused sheets inflate the file. And the machine itself runs out of memory, especially in 32-bit Excel.

The good news is that each cause has a fix, and most take only a few minutes. Start with the tips that match the symptoms you see: slow typing points to calculation, slow scrolling points to formatting and objects, and slow opening and saving points to file size.

12 Ways to Speed Up Excel at a Glance

1. Disable Excel Add-ins That Slow It Down

Add-ins can be useful, but if you have many installed or some are outdated, they slow Excel down every time it opens and can interfere with calculation.

To disable them, go to File, then Options, then Add-ins. At the bottom of the window, next to Manage, select Excel Add-ins and click Go. Uncheck any you do not need, then click OK. You can manage COM Add-ins from the same Manage list. Disable the ones you do not actively use, and Excel should start and run faster.

2. Switch Excel to Manual Calculation

By default, Excel recalculates formulas every time you make a change, which can bring a large workbook to a crawl. Switching to manual calculation stops that while you work.

Go to Formulas, then Calculation Options, and choose Manual. Excel now recalculates only when you tell it to: press F9 to calculate all open workbooks, or Shift+F9 for just the active sheet. Just remember to recalculate before you rely on the numbers, because results will be out of date until you do. Excel shows "Calculate" in the status bar as a reminder.

3. Replace Volatile Functions That Slow Excel Down

Volatile functions, such as NOW(), TODAY(), RAND(), OFFSET(), and INDIRECT(), recalculate every time anything changes in the workbook, even when the change has nothing to do with them. A few are harmless; thousands can slow a large workbook significantly. Microsoft's performance guidance recommends using INDEX instead of OFFSET and CHOOSE instead of INDIRECT.

Use volatile functions sparingly. Instead of NOW() in every row, for example, put one =TODAY() in a single cell and point your formulas at it, or type the date when it only needs to change occasionally.

4. Optimize Formulas in Large Excel Workbooks

Formulas that work on large ranges, older array formulas, and complex nested logic can drastically affect performance. Three habits help the most.

Limit the range. Array formulas and functions like SUMPRODUCT calculate every cell in a whole column (A:A), including a million empty rows. Point them at the range you need, such as A2:A5000, or better, convert the data to an Excel Table and use structured references that grow with the data. Everyday functions like SUM and SUMIF handle whole columns efficiently, so the biggest gains come from array-style formulas.

Use helper columns. Break a long formula into simpler steps spread across a few columns. Each step calculates once, instead of the same sub-calculation being repeated inside one giant formula.

Replace heavy array formulas. Array formulas are powerful but resource-intensive over large ranges. Where a regular formula, a lookup, or a PivotTable gets the same answer, use it instead.

5. Reduce Conditional Formatting in Large Files

Conditional formatting is useful for highlighting cells, but too many rules, or rules applied to entire columns, force Excel to evaluate a huge number of cells over and over.

Use fewer rules, and apply each one only to the range that needs it rather than whole rows or columns. To review what is there, go to Home, then Conditional Formatting, then Manage Rules, and choose This Worksheet to see every rule and its range. To remove rules you no longer need, use Home, then Conditional Formatting, then Clear Rules.

6. Compress Images and Remove Unused Objects

Large images and embedded objects, such as charts, shapes, and text boxes, make files heavier and slower to scroll and save. If you use many of them, reduce their size or keep them outside the workbook.

Compress images before or after inserting them: select a picture, then choose Picture Format, then Compress Pictures. For large reference files, link to them rather than embedding them.

7. Clear Excess Formatting and Reset the Used Range

Excess formatting increases file size and slows performance. The usual culprits are hidden formatting, extra cell styles, and formatting applied to entire rows or columns that stretches far beyond your data.

Select the unused cells or rows and go to Home, then Clear, then Clear Formats. A quick test: press Ctrl+End. If Excel jumps far below or to the right of your real data, the used range has grown. Delete the empty rows and columns beyond your data, then save, to shrink it. You can also use Find and Select on the Home tab to search for specific formatting.

8. Use Power Query for Large Data Sets

If you work with large data sets, Power Query is usually a much more efficient way to import, clean, and transform them than doing it with formulas in the workbook. It does the heavy lifting as a repeatable set of steps, so your sheets hold clean results instead of thousands of cleanup formulas.

Go to Data, then Get and Transform Data, and choose your source to load it into Power Query. Make the transformations there, then load the result into your workbook. Next time, click Refresh and the same steps run again.

9. Reduce Excel File Size

Workbooks gradually become bloated with old data, unused sheets, and leftovers from past projects. Removing what you no longer need reduces file size and improves speed.

Check the file size under File, then Info. If it seems unusually large, delete unused sheets and data, then use Save As to save a fresh copy, which can also drop leftover clutter.

10. Switch to 64-Bit Excel for Large Files

If you work with very large data sets, the 64-bit version of Excel can use far more memory than the 32-bit version and handles large files much better.

To check your version, go to File, then Account, then About Excel. The first line shows whether you are running 32-bit or 64-bit. If you are on 32-bit and regularly hit memory limits, ask your IT team about switching.

11. Save Large Workbooks as .xlsb (Excel Binary)

Saving a workbook in binary format (.xlsb) instead of the default .xlsx usually makes the file noticeably smaller, and large files often open and save faster. According to Microsoft, .xlsb files are typically about 1.5 times smaller than .xlsx.

Go to File, then Save As, and choose Excel Binary Workbook (*.xlsb) from the list of formats. The file works just like a normal workbook, including formulas and macros.

12. Keep Excel Updated for Performance Fixes

Make sure you are running the latest version of Excel, since updates often include performance improvements and bug fixes. Go to File, then Account, then Update Options, and choose Update Now.

Free Excel Speed Audit: Find What Is Slowing Your Workbook

Not every tip will help every file. Use the audit below to find the ones that matter for yours. Mark Yes for each problem your workbook has, such as volatile functions in many cells or conditional formatting on whole columns. Each problem is weighted by how much it typically affects speed.

The audit scores the workbook's speed-up potential and lists the fixes to try first, starting with the highest impact. The example shows a typical slow reporting workbook. Copy it to Excel with live formulas or print it as a checklist to work through.

How to Keep Large Excel Workbooks Fast

Large Excel workbooks can easily become slow and unresponsive, but these tips make a big difference. From optimizing formulas to removing unnecessary formatting, there are plenty of ways to make Excel faster. If you work with very large data sets, explore Power Query and consider 64-bit Excel.

Implementing just a few of these techniques lets you work more productively without the frustration of a lagging spreadsheet. And if a workbook has grown into the system your whole team runs on, Updoot is business management software that handles scheduling, time, projects, and budgets without the file size, for $5 per user per month. Learn Excel with me here.

Sources

Excel performance: Tips for optimizing performance obstructions (Microsoft Learn)