How to Fix Microsoft Excel When It Freezes or Stops Responding

Published 2026-10-16 · Marion Remote Fix

Microsoft Excel freezes when you open a large file. The title bar shows Not Responding and the spreadsheet becomes unclickable. Excel crashes when you try to use certain functions or features. Formulas take minutes to calculate. These problems range from annoying pauses to complete application crashes that risk losing your work. The causes are usually identifiable — large file sizes, excessive formulas, add-in conflicts, corrupted files, or insufficient system resources — and most have straightforward fixes.

Immediate recovery when Excel freezes

  • When Excel shows Not Responding, wait at least 30 to 60 seconds before taking action. Excel may be processing a complex calculation, loading a large file, or communicating with a network resource. What appears to be a freeze is sometimes just a long operation
  • If Excel is still frozen after waiting, you can try pressing the Escape key to cancel whatever operation is running. This works when Excel is stuck in a formula calculation or a lengthy operation that can be interrupted
  • If Escape does not work, open Task Manager (Ctrl+Shift+Esc), find Microsoft Excel in the process list, and click End Task. You will lose any unsaved changes, but AutoRecover should have a recent copy if it was enabled (it is enabled by default)
  • After ending Excel and reopening it, Excel should offer to recover your file from the AutoRecover backup. Check File, Info, Manage Workbook, Recover Unsaved Workbooks if the recovery prompt does not appear automatically

Large file and calculation issues

File size problems

  • Excel workbooks that have grown very large (over 20 to 50MB for xlsx files) often become slow and prone to freezing. File size grows from accumulated data, formatting, embedded objects, pivot cache, and hidden content
  • Check for unnecessary data: unused worksheets that contain old data, columns and rows that extend far beyond the actual data range, and cells that contain formatting but no data. Selecting the empty area beyond your data, right-clicking, and choosing Delete can reduce file size significantly
  • Embedded images, charts, and objects add to file size. If images are not needed at full resolution, consider compressing them or removing them
  • Saving as xlsx (compressed XML) instead of xls (the older binary format) typically produces smaller files. If the file is very large, the binary format xlsb can be even smaller and faster to load

Formula performance

  • Volatile functions like INDIRECT, OFFSET, NOW, TODAY, and RAND recalculate every time any cell changes. If these appear in many cells, each edit triggers a massive recalculation
  • VLOOKUP and INDEX-MATCH on large data ranges become slow as the data grows. If you are looking up values across tens of thousands of rows, consider using XLOOKUP (faster in modern Excel) or converting the data range to a Table for structured references
  • Array formulas that span large ranges and conditional formatting rules applied to entire columns (A:A instead of a specific range like A1:A1000) can cause severe calculation delays
  • Switch calculation mode to Manual (Formulas tab, Calculation Options, Manual) while making edits to prevent Excel from recalculating after every change. Press F9 when you want to recalculate. Remember to switch back to Automatic when finished

Add-in conflicts

  • Excel add-ins (both COM add-ins and Excel add-ins) run code inside Excel and can cause freezing, crashes, and performance problems if they are buggy or incompatible
  • Start Excel in Safe Mode to test without add-ins: hold Ctrl while clicking the Excel icon, and confirm when asked if you want to start in Safe Mode. Or press Windows+R and type excel /safe
  • If Excel works normally in Safe Mode, an add-in is the cause. Disable add-ins one at a time to identify the culprit: File, Options, Add-ins, select the add-in type at the bottom (COM Add-ins or Excel Add-ins), click Go, and uncheck add-ins individually
  • Common problematic add-ins include Bloomberg Terminal, Power Pivot with large data models, third-party data connection add-ins, and antivirus email scanning add-ins that hook into Office applications

Corrupted workbook

  • If one specific file always freezes or crashes Excel while other files work fine, the workbook may be corrupted
  • Try the built-in repair tool: File, Open, browse to the file location, click the dropdown arrow next to the Open button, and select Open and Repair. Excel attempts to repair the file and recover as much data as possible
  • If repair does not work, try opening the file and immediately copying the data (sheets or ranges) to a new blank workbook. Sometimes the corruption is in the workbook structure rather than the data itself, and copying the data to a fresh file eliminates the problem
  • Check if the file is on a network drive. Network latency or connectivity issues can cause Excel to freeze while reading or writing network files. Try copying the file to your local drive and opening it there

External data connections

  • Workbooks with connections to external data sources (databases, web queries, Power Query, linked workbooks) can freeze when those sources are unavailable, slow to respond, or returning large amounts of data
  • When opening a workbook with data connections, Excel may try to refresh the connections automatically. If the data source is unreachable (a database server that is down, a network drive that is disconnected, a web service that is not responding), Excel hangs while waiting for the connection to time out
  • Disable automatic refresh: Data tab, Connections, select the connection, Properties, and uncheck Refresh Data When Opening the File. This lets you open the workbook without waiting for data connections
  • If linked workbooks are causing the problem (formulas that reference cells in other files), Excel prompts to update links on open. Click Do Not Update if the linked files are not available. Update links manually when the source files are accessible

Insufficient system resources

  • Excel running on a computer with limited RAM may freeze when working with large datasets. Excel loaded with a large workbook can easily consume over 1GB of RAM, and if the system is already using most of its available memory, paging to disk causes severe slowdowns
  • Check Task Manager while Excel is running to see RAM and CPU usage. If RAM usage is consistently above 85 to 90%, closing other applications or adding more RAM helps
  • The 32-bit version of Excel is limited to approximately 2GB of memory regardless of how much RAM your system has. If you work with very large files, installing the 64-bit version of Excel removes this limitation

Conditional formatting overload

  • Excessive conditional formatting rules are a hidden cause of Excel slowness. Each rule must be evaluated for the cells it applies to, and rules accumulate over time — especially when copying and pasting cells, which duplicates the formatting rules
  • Check conditional formatting rules: Home tab, Conditional Formatting, Manage Rules. Select This Worksheet to see all rules. If there are dozens or hundreds of rules (often duplicate rules from copy-paste operations), delete the duplicates
  • Apply conditional formatting to specific ranges rather than entire columns. A rule applied to column A evaluates over a million cells. The same rule applied to A1:A1000 evaluates only the cells you need

Excel updates

  • Outdated versions of Excel may have known bugs that cause freezing or crashing. Microsoft regularly releases updates that fix performance issues and crashes
  • Check for updates: File, Account, Update Options, Update Now. Install any available updates and restart Excel
  • If a recent update caused the problem (Excel was working before the update), you can try rolling back the update through Windows Update history, or wait for Microsoft to release a fix in the next update

Office repair

  • If Excel consistently malfunctions regardless of the file being opened, the Office installation itself may be corrupted
  • Open Settings, Apps, Installed Apps, find Microsoft Office or Microsoft 365, click the three dots, and select Modify. Choose Quick Repair first — it fixes common issues without an internet connection and takes a few minutes
  • If Quick Repair does not help, run Online Repair. This downloads fresh Office components and replaces corrupted files. It takes longer but is more thorough

Need help with Excel problems?

If Excel continues to freeze or crash and the fixes above have not resolved the issue, or if you have a critical workbook that is corrupted and needs data recovery, Marion Remote Fix can remotely diagnose Excel performance issues, repair corrupted workbooks, optimize formulas and file structure, and resolve add-in conflicts.

← Back to Blog