Excel Filtering Drop Down (bug?)

Question

I'm an avid excel user and have been using it daily for close to 2 decades now. I've run into what I consider a very strange issue that neither myself nor my company IT professionals have been able to solve. 

It has to do with Data/Filter drop downs. 

I have filtering enabled on the top row of my worksheets, when i attempt to use the drop down (normally to deselect all and just choose a few options) the filter drop down automatically closes before I can make my selection.

We've done the following troubleshooting and the issue remains.

1. confirmed the problem is across multiple workbooks, including when a new workbook is made.  
2. confirmed the problem is isolated to my machine (other users do not have the same issue using the same workbooks)
3. confirmed the problem is both when using a wireless mouse and the laptop track pad
4. attempted to repair Office 365
5. confirmed all drivers, Office, and windows have all recent updates
6. turned off dual monitors to confirm it wasn't an issue there

<edit>

7. same issue in safe mode
8. same issue when trying to select using a drop down Filter in a pivot table

Any ideas what could be causing this?

Answer 1

Hi All,

For this issue, I'd like to share a summary which will benefit other community members.

Symptoms:

Users can't use Data/Filter or other drop downs in Excel clients.

Workaround:

Turn off Dropbox badge

https://www.dropbox.com/help/business/badge-on-off

Assessment:

The issue is related to Dropbox updates,  Dropbox team is working on it. You can subscribe to the following thread to get the latest updates.

Dropbox interfering with Excel, Word

Once there are any updates, we'll get back to you.

Regards.

Felix

Answer 2

Disabled the Dropbox Badge and problem went away:) 

https://www.dropboxforum.com/t5/Installation-and-desktop-app/Dropbox-interfering-with-Excel-Word/m-p/236604

Answer 3

Hi Eeshib,

Are you still experiencing the issue? If so, could you share a reproduce video with us?

Regards,

Joanne

Answer 4

OK, I'm officially at a loss... 

Problem will absolutely not happen as I'm recording. 

As soon as I'm not recording, same issue.

Answer 5

Hi Eeshib,

Are you using an application to record your screen? If so, please let us know as it seems to be affecting the behavior and use a phone to record instead of a screen recording.

Regards,

Sheen