Jul 15 2020
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.
Jul 18 2020
could you please attach your sample file along with screenshot of your steps
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more