logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

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


Range  ›  27 Delete Named Ranges with Invalid Cell References (#REF!)
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

Choose your language preference below

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

Download
Delete All Defined Range Names in Workbook




Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


🏆 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.