07-24-2019 11:36 AM
07-24-2019 11:41 AM
07-24-2019 11:51 AM
07-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.
07-25-2019 12:55 PM
07-26-2019 01:31 PM
07-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.
07-27-2019 05:37 AM
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
Hope that Helps