Upload a workbook to see its defined names, then remove the broken #REF! names, hidden names, or all of them, and download a cleaned copy. Runs in your browser.
ModelMint's Name Scrubber lists every defined name in a clean dialog, flags the broken ones, and removes them in bulk, right from the ribbon. $89 a year.
Defined names pile up in real workbooks: ranges whose cells were deleted leave behind broken #REF! names, and hidden names accumulate from copied sheets and templates. They clutter the Name Manager, can throw errors, and travel with the file when it is reused. This tool reads every defined name, counts the broken and hidden ones, and removes exactly the categories you choose, then gives you a cleaned copy. It only edits the defined-name list, so the rest of your workbook is untouched, and your original file is never changed.
How do I remove broken defined names in Excel?
Upload the workbook, pick the categories to remove, and download the cleaned copy. See our guide on removing defined names in Excel.
What is a #REF! defined name?
A named range whose reference was deleted, so it now points at #REF!. See what a named range is.
Is my file uploaded anywhere?
No. Everything runs locally in your browser, and your original is never modified.