Home Newsletter

Deze pagina in het NederlandsHome > Downloads > Name Manager

Name Manager: Range names made easy

For Microsoft® Excel®

Description

If you are in need of a utility to manage defined names in your Excel models, this one is a must-have. List all names in your active workbook. Filter them using 14 filters, e.g. "With external references", "With errors", Hidden, Visible. Show just names that contain a substring. Show just names unused in worksheet cells. Edit them in a simple dialog or make a list, edit the list and update all names in one go. Delete, hide, unhide selected names with a single mouse click.

Name Manager
See more screenshots here

Created in collaboration with Charles Williams, www.decisionmodels.com and Matthew Henson (mhenson@mac.com) who ensured the utility works on Mac Excel too.

The Name Manager is freeware, all I'd like to ask you is to tell everyone if you like it and to tell me if you don't.

Current version

This is the one to download if you are on any of these versions: ,2003,2007,2010,2013,2016,2019,2021,365 (both 32 and 64 bit versions)

Name Manager for recent Excel versions V4.5 (Build 692, May 16, 2022, downloaded: 116.948 times)

Old version

If you're still using one of the antique versions of Excel this is your download:

Name Manager for old Excel versions (97, 2000, XP and 2003) V4.3 (Build 655, Dec 13, 2016 Downloaded: 127.397 times)

Mac version

Mac users, for your convenience, Name Manager 2.3 (Downloaded: 11.172 times) is still available. Note that unfortunately NM is NOT compatible with Office 2016 for Mac.

Some users get a compile error during load of Name Manager: "Compile Error in hidden module, fxlNameManager".

In such a case, Name Manager will automatically turn off its feature to display a toolbar in the VBA editor.

This error is mostly resolved by running Office Setup from Control Panel, Programs and do a repair of the Office installation.

After doing so, Name Manager should work as expected.

Latest additions (in reverse chronological order:)

Features:

The Where is a name used dialog of Name Manager

Instructions

Download the zip file by clicking the link above that says "NameManager.zip". Unpack the files in the zip file to a folder of your liking and open the file called "Setup Name Manager.xls". Press the button in that file to install.

Click here to request support or issue comments or suggestions on this product.


Comments

Showing last 8 comments of 1062 in total (Show All Comments):

 


Comment by: Carl Watson (6-4-2022 13:26:00) deeplink to this comment

Hello,

Is the link on this page correct for Excel 365? (Seems to be pointing to version 4.3 rather than 4.5)

-Carl


Comment by: Jan Karel Pieterse (6-4-2022 13:35:00) deeplink to this comment

Hi Carl,

It is the latest version and build, it's just that the name of the instruction document is wrong. I have corrected this in the new download.


Comment by: Carl Watson (6-4-2022 14:29:00) deeplink to this comment

I'm having a problem with the add in after adding it to a WIN 10 (OS build 18362-1256) system running Office 365 (Version 2203 Build 15028.20160)

When Excel is open and I try to access the Add-in, I'm getting a Microsoft VB Error:
Run-time error '453':
Can't find DLL entry point FindWindowA in usew32

Any suggestions?

-Carl


Comment by: Jan Karel Pieterse (6-4-2022 15:13:00) deeplink to this comment

Hi Carl,

Is this on 32 or 64 bit Office please?


Comment by: Carl Watson (6-4-2022 15:22:00) deeplink to this comment

Hello,

System Manufacturer: LENOVO
System Model: 20N4002SUS
System Type: x64-based PC
System SKU: LENOVO_MT_20N4_BU_Think_FM_ThinkPad T590
Processor: Intel(R) Core(TM) i7-8665U CPU @ 1.90GHz, 2112 Mhz, 4 Core(s), 8 Logical Processor(s)
BIOS Version/Date: LENOVO N2IET95W (1.73 ), 4/27/2021

Hope this helps.


Comment by: Jan Karel Pieterse (6-4-2022 15:52:00) deeplink to this comment

Hi Carl,

Not really :-) I mean if you open Excel and open File, Account, About Excel, does the Bold line near the top have 32-bit or 64-bit mentioned at the end?

Mine says:
Microsoft® Excel® for Microsoft 365 MSO (Version 2202 Build 16.0.14931.20118) 32-bit


Comment by: GARY SMITH (14-5-2022 02:34:00) deeplink to this comment

I have scanned the documentation provided, impressive but I dont see how I can do a simple text find/replace

such as in as set of defined names: Apr_Scholarships_Expenses

I want to be able to Replace*_Scholarships_Expense with
_AE_Exp

Perhaps I missed it but any guidance appreciated.
Gary


Comment by: Jan Karel Pieterse (16-5-2022 09:38:00) deeplink to this comment

Hi Gary,

The documentation contain an example macro to do bulk-renaming.


Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.




To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].