I have a spreadsheet with three sheets and one table on each sheet. The default names are Table1, Table2, Table4. I used the cell name field to "rename" these tables to match the sheet name, but rather than replace the Table1, etc. I now show a list of six names, the original "TableX" name, and the three new ones I want to use. How do you get Excel to actually replace the default names rather than assigning an additional name? Will Excel not allow the table name and sheet name to be the same? Also, is it possible to delete a table name once it has been created?
Thanks.