Skip navigation

Show on which sheets a data source is used

score 89
You have not voted. Active

When pulling together multiple data sources, I inevitably end up with one or more data sources that I scrap during the creation process.  I try to clean as I go, but once you're in the flow sometimes the housekeeping gets set aside.  I'd like to right-click the data source and have an option in the menu that will tell me which sheets, if any, are using that data source.  The current warning is nice to let me know that a sheet is using it, but it would speed things up if I didn't have to click through the worksheets to find out which ones.

Comments

Vote history