Excel freezing — cursor stops responding mid-sheet, the title bar shows “(Not Responding)”, or scrolling through large data causes the window to lock up — is a common problem with a handful of reliable fixes. The cause is almost always one of: a file that’s too complex for Excel to handle smoothly, an add-in conflict, or a hardware acceleration issue. For the bigger picture, our Complete Guide to Fixing Windows, Browser, and Software Errors pulls everything together.
The fastest triage: does it freeze on all Excel files, or only specific ones? Open a new blank workbook (File → New → Blank Workbook). If Excel is responsive in a blank file but freezes on a specific spreadsheet: the issue is that file. If even a blank workbook freezes: it’s an Excel configuration or system issue.
File-specific freezing: large or complex spreadsheets
Excel handles data and formulas in RAM. Spreadsheets with tens of thousands of rows, heavy use of volatile formulas (OFFSET, INDIRECT, NOW, TODAY), or large amounts of conditional formatting recalculate constantly and can overwhelm Excel’s calculation engine — particularly on machines with limited RAM.
Quick wins for large-file performance:
- Switch to Manual Calculation: Formulas tab → Calculation Options → Manual. Excel won’t recalculate every time you make a change — press F9 to calculate when needed. This alone can eliminate freezing during data entry in large sheets
- Remove unused rows/columns: Excel’s “used range” includes blank rows with formatting. Ctrl+End to see the last used cell — if it’s far beyond your actual data, select the extra rows/columns and delete them properly (right-click → Delete, not just clear)
- Audit volatile formulas: replace OFFSET with INDEX where possible; use DATE instead of TODAY() in cells that don’t need to update daily
Fix 1: Disable hardware graphics acceleration
This is the most common fix for freezing that occurs during scrolling, zooming, or working with charts. Excel uses GPU acceleration for rendering; when the GPU driver is outdated or incompatible, Excel freezes during render operations.
File → Options → Advanced → Display → check “Disable hardware graphics acceleration” → OK → restart Excel. If freezing stops: the GPU driver was the cause. Update the GPU driver from the manufacturer’s website and then re-enable acceleration to restore performance.
Fix 2: Disable add-ins
Excel add-ins run in the same process as Excel itself. A buggy or outdated add-in can freeze Excel completely, often when certain actions trigger the add-in’s code (opening a file, switching sheets, inserting rows).
File → Options → Add-ins → at the bottom, Manage: COM Add-ins → Go → uncheck all → OK → restart Excel. If it stops freezing: re-enable add-ins one at a time until the freeze returns. Common culprits: Bloomberg data feeds, Power BI add-ins, older Acrobat PDFMaker, analysis toolpacks that haven’t been updated.
Fix 3: Check Excel’s temp file accumulation
Excel creates temporary files during autosave and recovery operations. On machines where Excel has been running for a long time or has crashed repeatedly, these temp files accumulate and occasionally cause Excel to freeze during file operations.
Navigate to %temp% in File Explorer (Win+R → type %temp% → Enter) → sort by Date modified → delete old Excel temp files (files starting with ~$, or .tmp files from Excel). Also clear: C:Users[username]AppDataRoamingMicrosoftExcelXLSTART — any files here load at Excel startup and can cause freezing if corrupted.
Fix 4: Office Quick Repair
Installation corruption in the Excel component causes persistent freezing that doesn’t respond to configuration changes. Settings → Apps → Microsoft 365 or Microsoft Office → Modify → Quick Repair. Takes about 5 minutes, requires no internet connection. Resolves the majority of Excel installation corruption.
Fix 5: Antivirus scanning Excel files
Security software that scans files in real time holds a read lock on Excel files while scanning. When Excel tries to autosave or access the file simultaneously, it waits for the scan lock to release — causing apparent freezing that lasts 5-30 seconds at predictable intervals (matching the autosave frequency).
Add the Office installation directory and frequently-used Excel file locations to the antivirus exclusion list. The risk is small — files in the Office folder are trusted executables, and excluding specific working document folders is an acceptable trade-off for reliable performance.
Fix 6: Open in Safe Mode
Hold Ctrl while clicking the Excel icon to launch in Safe Mode — no add-ins, no startup files, no custom toolbars. If Excel doesn’t freeze in Safe Mode: either an add-in (Fix 2) or a file in XLSTART is the cause. Safe Mode is the quickest way to confirm add-in vs installation issue in under 30 seconds.
OneDrive and SharePoint file freezing
Excel files stored in OneDrive or SharePoint with AutoSave enabled trigger continuous background sync. When OneDrive has a sync conflict, quota issue, or connectivity problem: Excel’s autosave operations block, and the workbook freezes briefly every time autosave tries. The freeze interval matches the autosave interval.
Test: File → Save As → save a copy to the local hard drive (not OneDrive) → open that local copy. If it doesn’t freeze: the OneDrive sync was causing the freezing. Resolve the OneDrive issue (check the sync icon for errors) or work locally and sync manually.
For Excel performance issues related to large datasets and Power Query, our Excel performance deep-dive covers memory optimisation, Power Query refresh settings, and data model configuration. For Office-wide performance issues affecting Excel alongside other applications, our Office troubleshooting guide covers the repair process and add-in isolation. Microsoft’s Excel performance documentation covers the Windows Registry-level Excel settings for computation threading, memory limits, and hardware acceleration configuration.
Clipboard and large copy operations
Copying a large range of cells in Excel fills the Windows clipboard with a potentially huge amount of formatted data. When the clipboard is full and another application (OneDrive, Teams, a clipboard manager) tries to access it simultaneously: Excel can freeze waiting for the clipboard operation to complete. The classic symptom: paste works fine, but copying a large range causes Excel to hang for 30+ seconds.
After copying a large range: press Escape before switching to another application — this releases the clipboard “marquee” (the animated dashed border) and reduces clipboard pressure. For large data transfers: consider copy-paste within Excel only, rather than between Excel and other applications, for the most complex data ranges.
Multi-threaded calculation settings
Excel uses multiple CPU cores for formula calculation. File → Options → Advanced → Formulas → “Enable multi-threaded calculation” is normally beneficial, but on machines with specific CPU configurations or driver conflicts, it can cause freezing during heavy calculation. Try disabling it and setting calculation to use 1 thread → test. If freezing stops during recalculation: re-enable with fewer threads than the default (try half the available core count).
Excel and external data connections
Excel workbooks with external data connections (to databases, web APIs, other Excel files) query those sources when the file opens or when data refreshes. If the external source is slow, unreachable, or requires authentication that hasn’t been completed: Excel waits for the connection to time out — which looks like freezing during the open or refresh operation.
Data tab → Queries and Connections → right-click each connection → Properties → uncheck “Refresh data when opening the file” for connections you don’t need to auto-refresh. Also check “Connection type” — connections pointing to network shares or databases that are currently unreachable are the most common cause of open-file freezing in Excel workbooks used in corporate environments.
Conditional formatting at scale
Conditional formatting applied to entire columns (rather than specific ranges) forces Excel to check every cell in those columns against the formatting rules every time anything in the sheet changes. A single “Format entire column A” rule applied to 1,048,576 cells causes performance problems even when only 1,000 cells have data.
Home → Conditional Formatting → Manage Rules → change “Show formatting rules for” to “This worksheet” → look for rules with ranges like A:A (entire column) → narrow them to A1:A10000 or wherever your data actually ends. Reducing the conditional formatting scope dramatically improves performance in large sheets.
Array formulas and CTRL+SHIFT+ENTER legacy formulas
Legacy array formulas (entered with Ctrl+Shift+Enter in older Excel versions) recalculate the entire array on every change, regardless of whether the relevant input cells changed. Large legacy array formulas in complex sheets are disproportionately expensive to recalculate.
In Excel 365, dynamic array formulas (using functions like FILTER, XLOOKUP, SEQUENCE) are more efficiently recalculated than legacy Ctrl+Shift+Enter arrays. If a sheet has many legacy array formulas causing freezing during recalculation: consider migrating to dynamic array equivalents. This requires Excel 365 and changes the formula syntax, but the performance improvement can be significant in complex analytical models.
Excel and Windows virtual memory
When Excel exhausts available RAM and Windows uses the page file (virtual memory on disk) for Excel’s data: performance degrades significantly. For very large workbooks on machines with less than 8 GB RAM: Excel’s working data spills to disk, causing freezing during any operation that accesses data that’s been paged out.
Task Manager → Memory → watch Excel’s memory usage as the freeze occurs. If Excel’s memory column shows near or above available physical RAM: add more RAM, close other memory-intensive applications while working in Excel, or split the workbook into smaller files. For Power Query models specifically: Data → Queries and Connections → Properties → check “Load to worksheet” only for queries you actively need on-screen; keep others in the data model only.
Corrupted workbook recovery
A specific workbook that consistently causes freezing (but other files work fine) may be partially corrupted. Before attempting complex recovery:
- File → Open → Browse → find the file → click the dropdown arrow next to “Open” → “Open and Repair”
- If Open and Repair succeeds but the file still freezes: the corruption is in formulas or formatting, not the file structure. Copy all data to a new workbook (Ctrl+A → Ctrl+C → new workbook → Paste Special → Values only) to strip the formulas and create a clean copy
- For SharePoint/OneDrive files: check version history (right-click on the cloud copy → Version History) and restore a version from before the freezing started
Excel 32-bit vs 64-bit memory limits
32-bit Excel (the default installation) is limited to approximately 2 GB of RAM regardless of how much RAM the machine has. For complex models: this limit is reachable. Check your Office version: File → Account → About Excel — if it shows “(32-bit)”: 64-bit Excel can be installed instead for larger memory headroom.
Switching to 64-bit requires uninstalling 32-bit Office and installing 64-bit — there’s no in-place upgrade. 64-bit compatibility is excellent in current Office versions, but some older 32-bit-only add-ins stop working. Check add-in compatibility before switching.
Quick diagnosis: what type of freeze is it?
| When does it freeze? | Likely cause | First fix |
| Scrolling or zooming in any file | Hardware graphics acceleration | File → Options → Advanced → disable GPU acceleration |
| Only on specific files | File complexity or corruption | Manual calculation mode; Open and Repair |
| During recalculation (F9 or typing) | Volatile formulas or large arrays | Reduce OFFSET/INDIRECT; manual calculation |
| When opening a file | External data connections or add-ins | Disable auto-refresh connections; disable add-ins |
| During autosave intervals | OneDrive sync conflict or antivirus lock | Save locally; add to antivirus exclusions |
| In any file, including blank | Installation corruption or add-in | Safe Mode test; Quick Repair |
Excel freezing is almost always solvable without reinstalling Office. The manual calculation mode and hardware acceleration disable address the two most common performance causes immediately. The add-in investigation and Quick Repair handle the configuration and installation cases. Understanding which category the freeze falls into — from the “when does it freeze?” diagnostic — directs the fix in the right direction without trial and error.
One more performance tip that makes a noticeable difference on older hardware: close all other applications before working in large Excel files. Excel’s memory usage expands to fill the available RAM as it caches formula results and cell history. When other applications are competing for the same memory pool: Excel performance degrades as Windows constantly swaps data between RAM and disk. On a machine with 8 GB RAM, closing a web browser with 20+ tabs before opening a complex Excel model can meaningfully reduce the frequency of freezes.
For financial models and analytical workbooks where freezing is a recurring problem: the professional approach is to split monolithic workbooks into input, calculation, and output files connected by external references. This allows each component to be calculated independently, keeps file sizes manageable, and eliminates the full-model recalculation that causes freezing in large all-in-one workbooks. It’s more complex to set up, but it’s how enterprise financial models handle the scale that causes Excel to struggle in single-file configurations. See also Excel Crashes in Windows 11 for a related case.
