The ASAP Utilities menu in Excel (English)
Delete Named Ranges with Invalid Cell References (#REF!)
ASAP Utilities › Range › 27. Delete Named Ranges with Invalid Cell References (#REF!)This tool deletes all named ranges in your workbook with invalid cell references (#REF!). Such broken references often occur when the referenced cells, rows, or worksheets have been deleted or renamed. After the cleanup, a summary report, created in a new workbook, lists all the named ranges that were deleted. Note:
Only the invalid names are removed. Your actual cell data and formulas remain unchanged.
Starting this tool
- Click ASAP Utilities › Range › 27. Delete Named Ranges with Invalid Cell References (#REF!)
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Additional keywords for this tool:
delete invalid named ranges, remove broken named ranges, #REF! error, Excel name manager cleanup, Excel remove invalid names, delete broken references, invalid name definition, Excel cleanup name manager, remove bad named range, fix #REF! in names, name manager #REF! error, delete name reference error, remove #REF! from name manager, named range points to deleted cell
delete invalid named ranges, remove broken named ranges, #REF! error, Excel name manager cleanup, Excel remove invalid names, delete broken references, invalid name definition, Excel cleanup name manager, remove bad named range, fix #REF! in names, name manager #REF! error, delete name reference error, remove #REF! from name manager, named range points to deleted cell
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
| Delete All Defined Range Names in Workbook |
©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.