Office
Sign in

Autofilter drop-down issue when cells exceeds 10000 in Excel for Office 365

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.

Excel UserVoice

See Also

Fixes or workarounds for recent issues in Excel for PC

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×