Forum Discussion
Locating a Data Validation table
How can I locate a drop-down list in an excel document that someone else created? I've been given a document that was already set up and I need to make changes.
=Table!$A$2:$A$7 This is the area in which the drop-down list is used, not the source of the list. It is hidden somewhere in the workbook.
