Tip of the Day | Wednesday November 26th, 2025

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

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.

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