Last Updated: July 8, 2022
ISSUE
Excel for Microsoft 365 might experience performance problems or stop responding when switching between worksheets of an existing file containing a PivotTable to which a filter has been applied.
The problem is known to affect the following builds 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
The fix for this problem is available in the following builds of Microsoft 365 Apps:
-
Current Channel: Version 2204 (Build 15128.20280) or later
-
Monthly Enterprise Channel: Version 2204 (Build 15128.20280)
The fix is expected to become available in the July 2022 update for the following channels for Office 365 subscription customers:
-
Semi-Annual Enterprise Channel: Version 2202
-
Semi-Annual Enterprise Channel (Preview): Version 2202
The fix will not be available for Office 2021 or Office 2019 customers.
WORKAROUND
If a fix is not available for your current version of Excel 365, you can work around the problem by removing the filter from the affected worksheet by selecting File > Home > Sort & Filter > Clear. Or you can work around the problem by setting a registry key by taking the following steps:
Important: This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, see Windows registry for advanced users.
-
Open Registry Editor by pressing the Windows logo key + R keys, typing regedit and pressing 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, with type REG_DWORD. If the value does not exist, create it by selecting Edit > New > DWORD (32-bit) Value and then typing DisableTouchUIA to set the name of the new registry value.
-
Select DisableTouchUIA and then select Modify... and set the Value Data to 1. Then select OK.
More Resources
Ask the experts
Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.
Get help in the community
Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.
Suggest a new feature
We love reading your suggestions and feedback! Share your thoughts. We're listening.
