Forum Discussion
Print list of Defined Names
I have an excel file in which I use over 80 defined named for different variables. I was careful to use a structured naming convention for the variable. I want someone else to be able to maintain it...
AstroGuy The very recently introduced Advanced Formula Environment could produce such a list. Search for it in the MS add-in list (Insert ribbon, Get Add-inns) and see it's available for your Excel version. If it is, then you can display a view like in the picture below.
Cut out the entire list and paste it in your data dictionary. It will also include named formulae.
Should this not work for you, Power Query can also list all named ranges (not named formulae) used within a workbook, though it does not include the ranges to which they refer.