A colleague has a worksheet with data validation lists/drop-down buttons. Someone who was working with her on the project asked me how to keep pasting the validation down for every day for the year so he wouldn't have to manually do the data validation for every cell. I had him Copy and then Paste Special and choose Validation. Ok, so it was working fine for a while.
Last week the colleague contacted me to say that when others went into the worksheet, they were unable to click on a day and get a drop-down after a certain date. I had her Paste Special and choose Validation again, and also had her copy the entire worksheet, but both times the drop-down buttons would disappear again after that one certain date.
The worksheet is shared. Could this be contributing to the problem? If not, why do the drop-down buttons keep disappearing? We're both very frustrated. :)