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.
this is nonsense. why do have to put vba code into our excel spreadsheet? This was not an issue with 2007, 2010 or 2013 versions it only appeared in the 2016 version of excel. This is a bug in excel accept it microsoft!
nothing to do with safe mode, it's an issue when the excel spreadsheet is saved and the current cell selected has data validation, when you re-open the spreadsheet the there is a drop down list.
Is there still no progress on this?
Hi Danny, did you try my workaround?
I'm waiting for Thao to reply to your messages....I've had it for months since i updated to 2016 version..
Cheers, Sean.
Is there anything I can do to keep these phantom boxes from popping up? Or anyway to remove them from a work-book?