Remove Broken Named ranges in Excel
This handy tool will list all named ranges within the current open workbook(s) and will show any that are broken. Simply highlight the name(s) that you wish to remove and this tool will remove them from the workbook(s).
This is a great little tool if you have multiple workbooks linking in with each other and your formulas suddenly stop working. Great time saving tool.