Maintaining an Excel... Differences Between ... then renaming them to remove the extensions. Note that any files with the same name but different extensions (such as "myfile.txt" and "myfile.odt ...

You can delete or change unwanted named ranges using the Excel Name Manager. Open Microsoft Excel, then click "File" and open the document containing the named range you want to delete.