Jul 24 2019 11:36 AM
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.
Jul 24 2019 11:41 AM
Jul 24 2019 11:44 AM
@PReagan Correct, but I am looking for the source of the list? It is somewhere within the workbook, but I cannot locate it.
Jul 24 2019 11:51 AM
Jul 24 2019 12:06 PM
=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.
Jul 25 2019 12:55 PM
Jul 26 2019 01:31 PM
Jul 26 2019 04:54 PM
@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.
Jul 27 2019 05:37 AM
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:
Here is a short tutorial about the Magic of the Inquire Tab
https://www.youtube.com/watch?v=yOHJJcXtQq4
Hope that Helps
Nabil Mourad
Mar 25 2021 01:25 PM
@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.