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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-08-20T13:57:29+00:00

    Hello,

    I was looking to several previously existing sheets that had the error. There I removed the cells' data validation as test. The "good" definitions vanished but the "bad" phantom drop down arrows and boxes didn't. Of course you are right, I should make the test with a completely new test worksheet, but

    • not every cell with data validation got that phantom staff. There is no visible system why some cells get it and others not.
    • it would be awful if I would have to redo all the programming again.

    regards

    Harald

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-08-19T21:55:44+00:00

    Harald,

      just trying to help here... by any chance you created a completely new test worksheet to validate, or you are looking to some previous example that was showing the issue?

    FWUser

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-08-19T21:48:58+00:00

    Let me amend: Although I had activated the automatic update I just started an update manually. Now I got Excel version 16.0.7167.2040 and still there are the phantom drop down boxes.

    regards

    Harald

    Was this answer helpful?

    0 comments
  4. Anonymous
    2016-08-19T21:43:29+00:00

    Harald,

     FWUser here, couple weeks after my last post on July 06 I got an update that fixed the issue for me, I have the O365 Subscription English version 16.0.6741.2056 right now and no phantom drop boxes at all.  So seems that could be an issue with the German version too.

    Hope the MS people could answer this

    regards,

    FWUser

    Was this answer helpful?

    0 comments
  5. Anonymous
    2016-08-19T21:12:21+00:00

    Hello Thao,

    Now it is more than a month from your answer and I (no Microsoft Insider) still have these awful phantom drop down boxes. Thao Moua wrote we have to wait for build 6868.xxxx. My Excel 2016 has meanwhile version 16.0.7070.2036. It's really awkward if you produce an Excel workbook for a customer and can't get rid of such ragged elements in the sheets which let you look like a dilletant. So PLEASE publish your patch for everybody as soon as possible. (By the way, I have a German version. I hope that makes no difference for that problem.)

    regards

    Harald

    Was this answer helpful?

    0 comments