Delete all range names with an invalid cell reference (#REF!)

Range › 27. Delete all range names with an invalid cell reference (#REF!)

This tool removes all range names that have an invalid reference (#REF!).
A report with the results will be presented to you.

Additional keywords for this tool:
#REF! error occurs when a cell reference is not valid, bad, incorrect, bad

©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 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.