Why it is highly recommended to delete unnecessary/unneeded range Names:
Large number of range Names makes it more difficult to locate a specific Name.
Range Names create references and unwanted links
To find unnecessary/unwanted range Names:
1. Select a cell in a new sheet.
2. Press F3 and click Paste List. A full list of range names and their references is pasted into the new sheet; delete each of the unwanted Name.