A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
This pattern matches an Excel display/rendering or workbook-environment issue more than a simple file corruption issue. Work through these checks in order:
- Install the latest Office and Windows updates Recent Excel updates include fixes for PivotTable refresh performance, freeze panes rendering, and geometric shape loading. Updating is the first step for hangs, freezes, and display problems.
- Test whether Excel is busy with another process Check the Excel status bar at the bottom of the window. If Excel is in use by another process, let that task finish before switching sheets or applying filters.
- Try Safe Mode troubleshooting Safe Mode bypasses Excel add-ins, startup folders, and most COM add-ins. If the issue does not occur in Safe Mode, the cause is likely an add-in or startup item.
- Check workbook content that commonly causes hangs or bad performance
Review whether the workbook has any of these:
- formulas referencing entire columns
- array formulas with uneven numbers of elements
- many hidden or zero-height/zero-width objects
- excessive styles from repeated copy/paste between workbooks
- excessive or invalid defined names
- very large numbers of shapes or complex shape objects
- If the problem is mainly with older or heavily formatted files, update Excel and retest Recent Excel updates improved handling of large numbers of shapes and complex objects, and can significantly improve load times for older files.
- Test the file locally Save a copy of the workbook to a local drive and test there. Problems can be related to where the file is stored, especially with network locations, web folders, SharePoint, Remote Desktop/Citrix, offline files, or virtualized environments.
- Test Manual calculation mode for complex workbooks
If the freeze happens when switching sheets or filtering a workbook with heavy formulas:
- Go to Formulas
- Select Calculation Options
- Choose Manual
- Check antivirus integration If antivirus software integrates with Excel, it can cause performance issues. Confirm the antivirus is up to date. If it has Excel integration or an Excel add-in, that integration can conflict with Excel. Important: Changing antivirus settings can make the PC vulnerable to malicious attacks. Use that workaround carefully.
- Perform a selective startup (clean boot) A background application, process, or service can conflict with Excel. A selective startup helps identify whether another program is causing the freezing.
- Repair Microsoft 365/Office programs Repairing the Office installation can resolve Excel not responding, hanging, or freezing.
- Check printer and video driver influence Excel checks the default printer and video drivers when it starts. Testing with a different printer driver such as Microsoft XPS Document Writer can help determine whether the issue is tied to a specific printer driver. The same applies to video driver-related rendering problems.
- If the workbook was generated by another application, test with a new workbook Files created by third-party applications can be generated incorrectly, which can cause features to fail or Excel to hang.
If the issue happens with multiple workbooks, especially when switching sheets and using filters, the highest-value checks are: update Excel/Windows, Safe Mode, clean boot, antivirus integration, local file test, and printer/video driver testing.
If the issue still continues after those steps, Microsoft Support is the next step for guided troubleshooting.
References: