Phantom Drop down boxes in excel 2016

Anonymous
2016-01-14T14:47:08+00:00

I use lots of data validation drop down list and recently some phantom boxes have been appearing in my spreadsheets.  You can select the grey arrow but the list is empty.  You then select the cell to get the correct data validation list, which appears to overlay the the box.  Can anyone help?  I created a new spreadsheet from scratch and it appeared to have fixed it but today i opened the spreadsheet and once again i have phantom drop down lists!!!

I removed all the data validation from the cell and it still remained!

Can anyone help?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

70 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2016-01-28T22:34:14+00:00

    Hi, 

    I am experiencing the same issue which has seemed to be developing since installing Excel 2016 and only noticing these issues in the last 3 weeks. 

    Using Windows 10 Pro

    Office 365 subscription V 16.0.6366.2062

    Excel 2016 MSO 16.0.6326.1022 32-bit

    I can private message you a copy of the workbook.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-01-29T01:45:53+00:00

    Thank you for your response.

    I am going to assume you're using Win10Pro x64.  Another question, are you on a desktop, tablet, or laptop?  While this usually doesn't matter, we have been seeing Office issues on Win10 with touchscreen laptop/tablet.

    If you can send the sample workbook to <username>@Microsoft.com, I'll investigate and report what I find.

    Thanks

    Thao Moua (Excel Desktop)

    ***Personal information deleted by the moderator. Please see the Microsoft Community Frequently Asked Questions for more information on how you can protect your privacy.***

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-01-29T18:56:15+00:00

    Hi Thao,

    Windows 10 Pro x64 is correct, and I am on a laptop without touchscreen. Also, I cannot see your email address and do not know how to private message you the sample workbook.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2016-01-29T19:23:35+00:00

    Let's try again.  Don't forget to vemove the spaces around the @ symbol.

    <username> @ Microsoft.com

    Thanks

    Thao Moua (Excel Desktop)

    ***Personal information deleted by the moderator. Please see the Microsoft Community Frequently Asked Questions for more information on how you can protect your privacy.***

    Was this answer helpful?

    0 comments
  5. Anonymous
    2016-02-04T21:56:29+00:00

    Is there anything I can do to keep these phantom boxes from popping up? Or anyway to remove them from a work-book?

    Was this answer helpful?

    0 comments