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.

  1. Open Registry Editor by pressing the Windows logo key + R keys, typing regedit and pressing Enter.

  2. Navigate to the following registry key:  HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options

  3. 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.

  4. Select DisableTouchUIA and then select Modify... and set the Value Data to 1.  Then select OK.

More Resources

Icon Experts (brain, gears)

Ask the experts

Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.

Excel Tech Community

Icon Community

Get help in the community

Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.

Excel Forum on Answers

Icon feature request (light bulb, idea)

Suggest a new feature

We love reading your suggestions and feedback! Share your thoughts. We're listening.

Provide feedback

See Also

Fixes or workarounds for recent issues in Excel for PC

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.