List of all ranges defined for a sheet

Huntb2000

Hi Folks,

We have been using a lot of cross sheet links and need to clean things up.

Is there a way to see all the named ranges used to access data in a sheet?  In other words, show all the ranges and thus the sheets, that are using data from the current sheet?

 

Thanks!

 

Andrée Starå

Hi,

Unfortunately, it's not possible at the moment to see a list of the ranges, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Huntb2000

Thanks Andree, Once again you have the answers.  Appreciate all you do for the community.

Andrée Starå

Thanks so much for the kind words!

I'm always happy to help! 

Have a fantastic weekend!

Paul Newcome

I would love to be able to quickly and easily get a comprehensive list of what is linked where. Until this becomes a feature, I have begun manually tracking my references on each of the source sheets.

 

It is a little bit of extra work, but it helps me keep everything straight. Since I am listing each reference on the source sheet, I am able to see the list whenever I link to the sheet again which helps with consistent naming conventions and helps avoid having more links than needed. 

Andrée Starå

Yes, that would be amazing!

Would make it so much easier when I'm working on different client solutions that aren't always structured the same.