×
英语
很抱歉。本文没有你的语言版本。

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

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×