Applies ToExcel 2016

Important:  This issue is now closed with the fix indicated below. For more information on other recent issues for your application, see Fixes or workarounds for recent Office issues.

Last Updated: September 14, 2017

ISSUE

When using Excel 2016, the AutoFilter drop-down may now show all available check boxes. This happens when the number of rows exceeds 10,000. Other symptoms may occur as well. For example, the check boxes may not be clickable, or the filtered result may not return expected results.

STATUS: FIXED

This issue is fixed in Monthly Channel Version 1707 (Build 8326.2073) and higher. To get the latest update immediately, open Excel and choose File > Account > Update Options > Update Now.

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

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.

Find solutions to common problems or get help from a support agent.