When I rename the table, Excel tells me that the name already exists. When I rename a range within excel to the same name, this works fine.
The name does not appear in the name manager and this only occurs when I format the item as a table.
I have pasted the table as plain text and renamed and this works fine. I then remove the name and convert to a table and rename and it once again tells me the name exists.
Any ideas would be welcome.
