Locating a Data Validation table

[ddsmith52]

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.

[#2]

Under the home tab > editing section > magnifying glass > "Go To Special" > Data validation.

This should highlight the cell that contains data validation for you.

[#3]

@PReagan   Correct, but I am looking for the source of the list?  It is somewhere within the workbook, but I cannot locate it.

[#4]

Click on the drop-down list > under Data Tab click Data Validation > Under Settings you should see the Source of the list.

[#5]

=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.

[#6]

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

[#7]

@ddsmith52 Does this help at all?

https://support.office.com/en-us/article/Add-or-remove-items-from-a-drop-down-list-0B26D3D1-3C4D-41F...

[#8]

@Ben Schorr   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.   

[#9]

@ddsmith52 

Hi

For situations like this (and MUCH more complicated) there is a Tool that comes for Rescue: The INQUIRE Tab of the Ribbon:

This tool will enable you to find a Table, data Validation, a Formula, Errors, not only if the Sheet is Hidden but even if the Sheet is VERY Hidden (VBA Term)

To add the INQUIRE TAB:

• File >> Options >> ADD Ins
• Manage (lower left corner) >> COM Add-ins >> Go
• Check INQUIRE >> Save the File >> Click on WORKBOOK analysis report...

Here is a short tutorial about the Magic of the Inquire Tab

https://www.youtube.com/watch?v=yOHJJcXtQq4

Hope that Helps

Nabil Mourad

[#10]

@ddsmith52 I have the exact same problem that you had. How did you unhide the tab? The author of the spreadsheet I am working on seems to have hidden this tab in a way that a simple right click on a tab to unhide is not enough.