Feb 19 2022 07:51 PM
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 and evolve it over time. To help that person, I would like to give a little explanation of the variable name (something akin to a data dictionary).
I do not see a capability for the Excel name manager to export a list of the name to a file or an added sheet in the file of interest. surely, someone has been down this path.
Feb 19 2022 10:16 PM
@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.
Feb 20 2022 09:09 AM
With hundred of names perhaps this tool Free Name Manager Excel add-in (jkp-ads.com) by @Jan Karel Pieterse will be useful.
Feb 21 2022 01:23 AM
Dec 06 2022 11:49 PM
Dec 07 2022 02:06 PM
Dec 07 2022 06:01 PM
i think the older version is me. i have just followed your instructions correctly and they worked. I now have what i was after.Thank you and apologies