Name Manager, now at Version 4, is a Excel Add-In that I find useful. Many times I have had to deal with workbooks with more than 100 names, many that are no longer valid. Name Manager helps manage such a mess.
If you are in need of a utility to manage defined names in your workbooks, this one is a must-have. List all names in your active workbook. Filter them using 13 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.
Available free at http://www.jkp-ads.com/officemarketplacenm-en.asp
Available for 97, 2000, XP, and 2003. And now a version for 2007.
Update (March 2008): Name Manager and Name Manager 2007 is now at version 4.1 (Build 599). New features: 1) When detecting unused names, all objects are searched as well as your VBA project. 2) A tiny but extremely handy toolbar to the VBE has been added. Selecting a name will paste that name at the current insertion point in your code!
Tags: add-ins
There is fine tool-How to recover Excel files, it supports almost all existing versions of XLS and XLSX formats: Microsoft Excel 97, 2000, XP, 2002, 2003 and 2007 (xlsx repair), recover style of table, recover number formats (except colors, used in a number format), recover fonts, recover worksheets, recover columns width and rows height, recover cell data of workbook, recover all types of formula including functions, internal, external and name references, recover cells format (font, number format, line style, fill pattern, text orientation an alignment) recover colors of cells,recover colors of cell’s borders.