Tip of the Day | Tuesday 21 July 2026

Discover new tools to get things done.

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

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Tip:Alt+P for the previous tool.