This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
Hello all.
The fix will be in build 6868.xxxx. If you are on an Insider build, you will get the fix soon than non-Insider. Eventually everyone will get the fix.
Thao Moua
Excel Desktop
chating with a MS technician now... this are his answers:
"Thank you for that information. We'll raise this up now to our engineering team, Once a patch for this is available within today it will be sent out to your computer via Windows Update or email your . My recommendation for the meantime is to keep checking the Windows Update Option. "... and then
"The case is still unresolved. And I can't open it here on my end, someone is still holding the case."
Oh... well.... another day on MS paradise
06/11/2016 - FANTASTIC NEWS everyone. Very recently, Microsoft FINALLY released a patch to Excel 2016. Update your software. The bug in the software is now fixed! No more phantom dropdown boxes!!
And to Microsoft tech support monitoring this, pass along my thanks for fixing this problem. <Case number removed for privacy>.
***Personal information deleted by the moderator. Please see the Microsoft Community Frequently Asked Questions for more information on how you can protect your privacy.***
The patch is for what version of excel?...
Asking because I do have a Office 2016 Pro-plus Subscription, using Excel version 16.0.6741.2048, running on Windows 7 Pro 64bits on my office PC and the problem still there.
I just waste few hours trying to find the issue, thanks to this thread I learned of the bug, I already tried to find out if an update was available, but is not.
Is there something that I'm not seeing or not aware of?
How I can access the case to put an update on it?
Thanks
06/11/2016 - FANTASTIC NEWS everyone. Very recently, Microsoft FINALLY released a patch to Excel 2016. Update your software. The bug in the software is now fixed! No more phantom dropdown boxes!!
And to Microsoft tech support monitoring this, pass along my thanks for fixing this problem. <Case number removed for privacy>.
***Personal information deleted by the moderator. Please see the Microsoft Community Frequently Asked Questions for more information on how you can protect your privacy.***
As has been noted further on, Addons are NOT the problem. There was a documented bug in the program. I know because I worked extensively with top level tech support and developers at Microsoft to identify the bug.
As of this writing, I am happy to announce, Microsoft has finally released a patch for the bug. Excel 2016 no longer creates Phantom Dropdown boxes.