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