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.
PReagan Correct, but I am looking for the source of the list? It is somewhere within the workbook, but I cannot locate it.
Click on the drop-down list > under Data Tab click Data Validation > Under Settings you should see the Source of the list.
=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.
BenSchorr Thank you. The mystery has been solved. The author of the document had hidden a tab where the drop-down list was located. When opening the Data Validation dialog box it referenced "=Table!$A$2:$A$7, but I wasn't able to locate the word "table" in searching each tab. A co-worker showed me how to unhide the tabs.
- I apologize but I must be misunderstanding your question. Would you mind sharing your workbook so that I may be able to understand your question a little better?
**Please omit any sensitive/confidential information
