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.
Obviously it is a bug in Excel, but at least this can fix existing workbooks. By using the VBA code supplied, you can erase the phantom validation boxes and then you can delete the VBA code afterwards.
my workbooks are edited on a daily basis and emailed and returned, so when i get it returned it has phantom boxes. every time i or person i've emailed workbook to forget to select a cell that does not have data validation this vba script has to be ran....this is not a feasible solution for me...or anyone....
I apologize, but we have not been able to repro this bug.
The provided VBA code is only a short term solution to remove the unwanted controls.
Thanks
Thao Moua (Excel Desktop)
i save everything to onedrive. my spreadsheets open up asking to update, its then these boxes appear..as i have links in my spreadsheets to external spreadsheets...could this be issue?
Hello Sean.
Can you provide a sample workbook showing the issue? Can you try with a sample workbook and remove the external references? I don't believe they are related but it is too early to rule things out.
Thanks
Thao Moua (Excel Desktop)