Tip of the Day | Tuesday 21 July 2026

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