Forum Discussion
Data Validation is no longer working correctly
Hello,
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.
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?
