8 Proven Fixes for Excel Spreadsheet speed & performance

Key takeaways

  • Most slow Excel workbooks follow predictable patterns, such as volatile formulas, excess conditional formatting, external links, broken named ranges and hidden objects, and can be fixed without rebuilding.
  • Start with a diagnostic: switch calculation to manual to see whether formulas are the bottleneck, check the file size, and press Ctrl + End to find excess formatted rows.
  • The highest-impact fixes are replacing volatile formulas like INDIRECT and OFFSET with INDEX or direct references, and restricting conditional formatting rules to the actual data range.
  • Further gains come from breaking unneeded external links, deleting #REF! names and hidden objects, sharing PivotTable caches, using manual calculation strategically and saving large files as .xlsb.
automate excel workbooks: slow Excel spreadsheet speed diagnostic screen showing charts and data overload.
Excel Spreadsheet Speed review mockup

Excel spreadsheet speed depends on how much work Excel does after every change: it calculates every formula, renders every object and loads every connection, so volatile formulas, excess formatting and hidden objects slow a workbook down.

If your Excel file takes forever to open, freezes while scrolling, or crashes when you add a formula, you are not alone. Slow workbooks are one of the most common frustrations for professionals who rely on spreadsheets every day. Fortunately, most performance issues follow predictable patterns and they can be fixed.

In this tutorial, you will learn how to diagnose what is dragging your file down and apply 8 targeted fixes that actually work. Whether you are managing a financial model, a sales tracker, or a data dashboard, these steps will help you automate Excel spreadsheets in a faster, more reliable way.

In this article
  1. Why Does Excel Slow Down?
  2. Step 1: Run a Quick Diagnostic
  3. Fix 1: Replace Volatile Formulas
  4. Fix 2: Limit Conditional Formatting
  5. Fix 3: Break External Links
  6. Fix 4: Remove Unused Named Ranges
  7. Fix 5: Clean Up Hidden Objects
  8. Fix 6: Optimize PivotTables
  9. Fix 7: Switch to Manual Calculation (Strategically)
  10. Fix 8: Save as .xlsb Format
  11. When DIY Fixes Are Not Enough
  12. Is your Excel workbook performing at its best?

Why Does Excel Slow Down?

Before jumping to solutions, it helps to understand the root causes. Excel calculates every formula, renders every object, and loads every connection each time a change is made. Consequently, a workbook with hundreds of volatile formulas, embedded images, and external links can bring even a modern machine to its knees.

Common culprits include:

  • Volatile formulas recalculating constantly (such as TODAY(), NOW(), INDIRECT(), OFFSET())
  • Excessive conditional formatting rules accumulated over time
  • Linked external data sources that time out
  • Unused named ranges and broken references cluttering the file
  • Large numbers of embedded objects like images or charts placed across multiple sheets

Understanding the cause is the first step. Therefore, start with a proper diagnostic before making any changes.

Step 1: Run a Quick Diagnostic

Open the workbook and navigate to File > Options > Formulas. Under “Calculation options”, temporarily set Workbook Calculation to Manual. This immediately tells you whether formulas are the bottleneck: if the file becomes fast right away, volatile formulas are your primary problem.

Additionally, check the file size. A healthy, data-only workbook rarely exceeds 5 MB. If yours is 30 MB or more without embedded media, something is hiding inside and often thousands of invisible formatting cells or ghost objects left behind from copy-paste operations.

Use Ctrl + End to find the last used cell. If it lands far below your actual data, you have excess formatted rows dragging performance down.

Not sure what is dragging your workbook down? Describe how the file behaves and talk it through with our specialists.

Talk to a specialist

Excel spreadsheet speed review before and after performance optimization comparison
Mockup of an Excel speed review

Fix 1: Replace Volatile Formulas

Volatile formulas recalculate every single time anything in the workbook changes, even if their inputs did not change. As a result, a single INDIRECT() referencing 10,000 rows can trigger thousands of unnecessary calculations per second.

Replace OFFSET() and INDIRECT() with INDEX() or direct cell references wherever possible. Similarly, replace TODAY() or NOW() in calculations with a static timestamp updated by a macro only when needed. This change alone can reduce calculation time by 40-60% in formula-heavy files.

Fix 2: Limit Conditional Formatting

Conditional formatting is useful, but Excel stores every rule: including duplicate and conflicting ones even when they are invisible or redundant. Over months of editing, a single sheet can accumulate hundreds of overlapping rules.

Go to Home > Conditional Formatting > Manage Rules and audit every sheet. Delete rules that apply to entire columns (e.g., A:A) and restrict them only to the actual data range (e.g., A2:A500). This straightforward cleanup often cuts rendering time in half.

External links to other workbooks force Excel to re-query source files every time the workbook opens. Moreover, if those source files have moved or been renamed, Excel gets stuck in a retry loop.

Navigate to Data > Edit Links and remove any links that are no longer needed. For links you want to keep, consider pasting values (Ctrl + Alt + V, then Values) and refreshing data manually through a controlled macro instead.

Fix 4: Remove Unused Named Ranges

Named ranges are helpful for readability, but broken or outdated ones create background overhead. Go to Formulas > Name Manager and look for entries marked with errors (#REF!). Delete them all. This is a quick fix with no side effects on your active formulas.

Fix 5: Clean Up Hidden Objects

Invisible shapes, text boxes, and images left from copy-paste operations are one of the most overlooked causes of slow Excel files. They exist on the sheet but are invisible to the eye but yet Excel still renders them.

Press Ctrl + G > Special > Objects to select all objects on the sheet. Delete anything you do not recognize or need. In extreme cases, users have found thousands of hidden objects that inflated a file from 2 MB to over 80 MB.

Fix 6: Optimize PivotTables

PivotTables cache a full copy of source data internally. Therefore, if you have multiple PivotTables referencing the same data source, each one stores its own copy. Consolidate them to share a single cache by creating each additional PivotTable from an existing one (not from the raw data range directly).

Also, disable “Save source data with file” in PivotTable Options when the source data is already in the same workbook.

Fix 7: Switch to Manual Calculation (Strategically)

For large models that do not need to recalculate constantly, keeping Excel in Manual Calculation mode is a practical long-term solution. Use Formulas > Calculation Options > Manual and press F9 only when you are ready to refresh the model.

However, remember to add a visual reminder on the sheet, a colored cell or label indicating that the file is in manual mode. Otherwise, users may act on stale data without realizing it.

Fix 8: Save as .xlsb Format

The .xlsb (Binary Workbook) format stores data in a compressed binary structure instead of XML, which is the format used by the standard .xlsx extension. For large files, switching to .xlsb can reduce file size by up to 75% and dramatically improve open/save speed.

To convert: File > Save As > change the file type to Excel Binary Workbook (.xlsb). Note that .xlsb files have minor limitations (some XML-based add-ins may not be compatible), so test before committing to the format in a shared environment.

FixWhere to do itWhat it solves
1. Replace volatile formulasSwap OFFSET() and INDIRECT() for INDEX() or direct cell referencesFormulas recalculating every time anything changes
2. Limit conditional formattingHome > Conditional Formatting > Manage RulesDuplicate rules and rules applied to entire columns
3. Break external linksData > Edit LinksExcel re-querying source files every time the workbook opens
4. Remove unused named rangesFormulas > Name ManagerBroken (#REF!) names creating background overhead
5. Clean up hidden objectsCtrl + G > Special > ObjectsInvisible shapes, text boxes and images left from copy-paste
6. Optimise PivotTablesCreate each extra PivotTable from an existing oneEvery PivotTable storing its own copy of the same data
7. Use manual calculationFormulas > Calculation Options > ManualLarge models recalculating constantly
8. Save as .xlsbFile > Save As > Excel Binary WorkbookLarge file size and slow open and save

When DIY Fixes Are Not Enough

These eight steps solve the majority of slow-workbook problems. However, some workbooks have structural issues rooted in poor initial architecture oversized data models, inefficient VBA code, or the wrong tool being used for the job entirely.

In those situations, patching individual formulas is not enough. A professional review of the file’s structure, calculation logic, and data flow is the right move. Specialists in building custom Excel spreadsheets can rebuild the core model in a way that scales without the performance debt.

Is your Excel workbook performing at its best?

A slow Excel workbook is a productivity killer. Fortunately, with the right diagnostic approach and these eight targeted fixes, most files can be brought back to speed without rebuilding from scratch. Start with the diagnostic, apply the high-impact fixes first (volatile formulas and conditional formatting), and work your way through the list systematically.

If you need a workbook that performs reliably at scale, the best path is working with specialists who design for performance from the start. With custom spreadsheets built correctly, you eliminate the need to fix what should never have been broken.

If the problem is the structure of the workbook rather than a few formulas, patching will not be enough. Tell us what the file does and how large it has grown.

Email our specialists

Frequently asked questions

What is slowing down my Excel spreadsheet?
Excel calculates every formula, renders every object and loads every connection each time a change is made. Common culprits are volatile formulas, excess conditional formatting rules, external links, broken named ranges and embedded or hidden objects.
How can I tell if formulas are the bottleneck?
Go to File > Options > Formulas and temporarily set Workbook Calculation to Manual. If the file becomes fast right away, volatile formulas are your primary problem.
Which formulas should I replace to speed up Excel?
Replace OFFSET() and INDIRECT() with INDEX() or direct cell references wherever possible. Replace TODAY() or NOW() in calculations with a static timestamp that a macro updates only when needed.
Does saving as .xlsb make Excel faster?
The .xlsb format stores data in a compressed binary structure instead of XML, which can reduce file size and improve open and save speed for large files. Some XML-based add-ins may not be compatible, so test it before using it in a shared environment.
When are DIY fixes not enough?
When a workbook has structural issues, such as poor initial architecture, oversized data models, inefficient VBA code or the wrong tool for the job, patching individual formulas will not solve it. A professional review of the file’s structure, calculation logic and data flow is the right move.

Content produced by Sapphire Business Technology, based on expertise developed across more than 500 satisfied clients in Excel and data automation consulting.

Picture of Douglas Reis

Douglas Reis

Technology enthusiast and founder of Sapphire Business Technology.

Connect on LinkedIn

Want a free gift? Acquire below.

Business Finance

  • Dashboards: cash flow, customer and supplier analysis
  • Records: customers, suppliers and bank accounts
  • Income: one-off and recurring
  • Expenses: one-off and recurring
  • Planning: sales and spending
  • Extras: PDF reports (monthly P&L, income and expenses)

Inventory

  • Dashboards: stock value and quantity, customers and suppliers
  • Records: products, suppliers and buyers
  • Stock in: one-off and scheduled
  • Stock out: one-off, scheduled and losses
  • Extras: transaction reports by product and customer

CRM/Sales

  • Leads tracked through the sales funnel
  • Record of closed deals
  • Commercial cost of each sale

Pricing

  • Cost of each product
  • Margin per product
  • Ideal selling price

Want a free gift? Acquire below.

Business Finance

  •  

Inventory

  •  

CRM/Sales

  •  

Pricing

  •  

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *