Fix Excel Filter Drop-Down Menus That Close Before Selection
Question details
The user needs Excel filter menus to remain open long enough to select filter options.

- Product
- Microsoft Excel and Dropbox desktop application
- Device & OS
- Windows 7
- Scenario
- The user opens a worksheet or PivotTable filter and moves the pointer to choose an option.
- Observed behavior
- The drop-down closes as soon as the pointer moves, including in new workbooks and Excel Safe Mode.
Check whether the Dropbox desktop application is running in the Windows notification area. Open an Excel workbook with a filter so you can test the menu after changing the Dropbox setting.
Disable the Dropbox Badge and Test the Excel Filter
Use this solution if Dropbox is running and Excel filter menus close as you move the pointer.
The Dropbox Badge has been reported to interfere with Excel and Word drop-down menus. Turning it off resolved the issue for users in the reported case.
Click the Dropbox icon in the Windows notification area, click your profile picture or initials, and select Preferences.
On the General tab, find Dropbox Badge and select Never show. The setting name or location may vary by Dropbox version.
Return to Excel, click a filter arrow, and move the pointer over the list to check whether the menu stays open.

Temporarily Quit Dropbox to Check for Interference
Use this check if the badge setting is unavailable or you want to confirm whether Dropbox is involved.
Work With Spreadsheet Filters in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel workbooks and use filters in WPS Spreadsheets for an easier transition, although it does not fix Excel's Dropbox interference.

Frequently Asked Questions
Why does my Excel filter menu close when I move the mouse?
The Dropbox Badge has been reported to interfere with Excel drop-down menus. Open Dropbox Preferences and try setting Dropbox Badge to Never show.
Can Dropbox affect PivotTable filters too?
Yes. The reported behavior also occurred with PivotTable filters. Disable the Dropbox Badge, then click a PivotTable filter arrow and test the menu again.
Does Excel Safe Mode rule out Dropbox interference?
No. The reported issue persisted in Excel Safe Mode. Because Dropbox runs separately, try quitting it from its notification-area menu and retesting the filter.
What happens if I quit Dropbox to test Excel?
Dropbox desktop syncing stops while the app is closed. Reopen Dropbox from the Windows Start menu after testing to resume syncing.




