Excel Range Name Tool
Since Excel range names are necessary to use Excel with our document creation services, we thought it would be a good idea to let other people “in” on our range name secrets. For LOOPlus, one of our products on Salesforce AppExchange, range names are used to map Salesforce fields into an Excel file for Dynamic Document PackagesTM. In our soon to be released LOOP Exchange platform, range names map from fields on a web form to an Excel file then possibly to a Microsoft Word or PowerPoint file. As you can see, Excel range names are an important part of our lives.
Excel tries to make it easy to create and delete range names and modify which cells a range name refers to, but what if you need to do more than that? Jan Karel Pieterse (in collaboration with Decision Models, UK) developed a great range name tool called Name Manager 4.0 that shows you a list of range names which you can filter by scope, names containing text, hidden names, 2-d multi-area names, and much more. This tool has the standard range name functions, add, delete, edit the ‘refers to’ formula, as well as some handy and necessary functions like editing the actual range name (which also gives you the option to edit the range name in all formulas that reference that name).
Watch nowYou can download Name Manager 4.0 here.
