Hello. I am attempting to define a range, from A2 to A56. I do so and the range is named ‘categories’ and the range definition is:
However, when I set this range to the ‘cell range’ of the data validity of a cell, say C1, the last three items in the range do not appear in the drop down selection for that cell C1. I have been trying combinations of ‘Expand cell…’ and recalculate and saving, closing, reopening and changing the validity to all values then back to that cell range. Nothing helps!
I still have a defined range with missing values. I appreciate any help!