A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
If the issue is that Excel is freezing or not responding after the Microsoft 365 upgrade, use this order:
- Install the latest updates
In Excel, go to File > Account > Update Options > Update Now. Recent versions include fixes for freeze panes rendering and other performance issues. - Check whether Excel is busy with another process
Look at the status bar at the bottom of the Excel window. If Excel is processing something, wait for it to finish before trying more actions. - Repair Microsoft 365
If updates do not fix it, repair Office. This can resolve Excel not responding, hanging, or freezing. - Try a selective startup (clean boot)
Background apps and services can conflict with Excel. A selective startup can help identify whether another program is causing the freezing. - If the freezing happens when opening or saving files and Excel asks to grant file access
Update to version 16.34 or later, because that specific issue was fixed in that version.
If the question is about frozen panes inside a worksheet, not app freezing, then removing frozen panes can be done in code with unfreeze():
- Office Scripts:
WorksheetFreezePanes.unfreeze() - Excel JavaScript API:
sheet.freezePanes.unfreeze()
References
- Excel not responding, hangs, freezes or stops working
- Excel not responding, hangs, freezes or stops working
- Excel not responding, hangs, freezes or stops working
- Excel prompts you to grant access to files and then hangs or shows a warning that it cannot open the .xlsx file because the format or extension is not valid
- Excel.WorksheetFreezePanes class
- ExcelScript.WorksheetFreezePanes interface