Excel Dependent Drop Down Lists not loading
Hello everyone.
I created Dependent Drop Down Lists in Excel using the Offset Formula.
When I open the sheet, the Drop Down Lists do not load but when I re-enter the same formula in Data Validation in the open sheet, the Drop Down Lists start loading / showing.
The same thing then repeats when I close and open the sheet.
Please help.
Hello everyone. I created Dependent Drop Down Lists in Excel using the Offset Formula. When I open the sheet, the Drop Down Lists do not load but when I re-enter the same formula in Data Validation in the open sheet, the Drop Down Lists start loading / showing. The same thing then repeats when I close and open the sheet. Please help. Read More