Hi, guys!
I made an excel file and I created some predefined lists usind Data>Validation>List and a named range. I made a list (Ctrl+L) containing the named range so it will automatically extend each time the user enters a value in the list.
The method was working perfectly BUT after 2 months of using this file, a guy tells me "the blue rectangles" has disappeared. My question is: How could they do that? There were more than 20 lists in that file and now there is no one left... and the guy sais "I didn't do anything". I'm a little bit confused so, if you have any idea... please help
I made an excel file and I created some predefined lists usind Data>Validation>List and a named range. I made a list (Ctrl+L) containing the named range so it will automatically extend each time the user enters a value in the list.
The method was working perfectly BUT after 2 months of using this file, a guy tells me "the blue rectangles" has disappeared. My question is: How could they do that? There were more than 20 lists in that file and now there is no one left... and the guy sais "I didn't do anything". I'm a little bit confused so, if you have any idea... please help