Data Validation is no longer working correctly

Copper Contributor



The drop down lists I created through data valuation are suddenly returning incomplete and incorrect lists.  Blank spaces are no longer showing up, there are missing items in between other items, and there is a blank grey line that I cannot figure out where it is coming from.  The spreadsheet was created in 2018 and has been working fine up until now.  I have tried everything including copying the info into a blank workbook and restating both excel and my computer multiple times.  Anyone else have this issue and know how to fix it?  I feel like it is a global excel issue and not a specific workbook issue.


Any help would be greatly appreciated.  Thanks.

1 Reply


Absent the ability to look at the actual, it's difficult for anybody to offer a diagnosis UNLESS they've experienced exactly the same thing. I suspect that's why, after nearly 80 views, you've had no responses.


Is it possible for you to post a copy of the actual workbook on OneDrive or GoogleDrive, pasting a link here that grants access?