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.
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
**Please omit any sensitive/confidential information