Microsoft has released multiple fixes to address performance issues and random unexpected crashes of Microsoft 365 Office applications. Microsoft recently released a fix for a crash issue in which Office version 2205 applications crashed when trying to use cloud-based files. Word, Excel, and PowerPoint are all affected. This fix has been implemented in Office version 2206.
Microsoft describes the issue and how it came with a fix:
The problem
Word, Excel, and PowerPoint may close unexpectedly when opening, closing, saving, uploading, or downloading cloud files in Office version 2205. No error is displayed when the app is closed abruptly.
Status: Fixed
This issue has been fixed in Office version 2206 (Build 16.0.15330.20230). The fix is rolling out to users via an update. You can install updates manually by opening an Office app and selecting File > Account > Update Options > Update Now.
Microsoft has addressed performance issues with Excel in Office 365, including freezing issues when switching between worksheets that contain filtered pivot tables. Microsoft describes this issue and its accompanying fix in its support document.
The problem
Excel for Microsoft 365 may experience performance issues or stop responding when switching between existing file sheets that contain pivot tables with filters applied.
This issue is known to affect the following versions of Microsoft 365 Apps:
- Office 365 Semi-Annual Enterprise Channel Version 2108 (Build 14326.20962)
- Office 365 Semi-Annual Enterprise Channel (Preview) Version 2202 (Build 14931.20392)
- Office 365 Monthly Enterprise Channel (MEC) Version 2203 (Build 15028.20248)
Status: Fixed
A fix for this issue is available in the following Microsoft 365 Apps versions:
- Current Channel: Version 2204 (Build 15128.20280) or later
- Monthly Enterprise Channel: Build 2204 (Build 15128.20280)
The fix is expected to be available in the July 2022 Update for Office 365 subscription customers in the following channels:
- Semi-Annual Enterprise Channel: Version 2202
- Semi-Annual Enterprise Channel (Preview): Version 2202″
Microsoft notes that the freeze fix won’t work with Office 2021 or Office 2019. So the company also offers a workaround.
Solution
If there is no fix available for your current version of Excel 365, you can resolve this issue by selecting File > Home > Sort & Filters > Clear to remove the filter from the affected worksheets. “
Microsoft also offers a way to fix the problem using registry tweaks:
- Press the Windows logo key + R to open the Registry Editor, type regedit, and press Enter.
- Navigate to the following registry key:
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options
- In the right pane, locate the registry value DisableTouchUIA of type REG_DWORD. If the value does not exist, create it by selecting Edit > New > DWORD (32-bit) Value and typing DisableTouchUIA to set the name of the new registry value.
- Select DisableTouchUIA, then Modify… and set Value Data to 1. Then select OK. “
If you like our news and you want to be the first to get notifications of the latest news, then follow us on Twitter and Facebook page and join our Telegram channel. Also, you can follow us on Google News for regular updates.