Jul 15 2020 07:11 AM
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 11:52 PM
Hi @willoxy
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