Error While Naming a Table

%3CLINGO-SUB%20id%3D%22lingo-sub-1523532%22%20slang%3D%22en-US%22%3EError%20While%20Naming%20a%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1523532%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20rename%20the%20table%2C%20Excel%20tells%20me%20that%20the%20name%20already%20exists.%20When%20I%20rename%20a%20range%20within%20excel%20to%20the%20same%20name%2C%20this%20works%20fine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20name%20does%20not%20appear%20in%20the%20name%20manager%20and%20this%20only%20occurs%20when%20I%20format%20the%20item%20as%20a%20table.%3C%2FP%3E%3CP%3EI%20have%20pasted%20the%20table%20as%20plain%20text%20and%20renamed%20and%20this%20works%20fine.%20I%20then%20remove%20the%20name%20and%20convert%20to%20a%20table%20and%20rename%20and%20it%20once%20again%20tells%20me%20the%20name%20exists.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20would%20be%20welcome.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1523532%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1531551%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20While%20Naming%20a%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1531551%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F728784%22%20target%3D%22_blank%22%3E%40willoxy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecould%20you%20please%20attach%20your%20sample%20file%20along%20with%20screenshot%20of%20your%20steps%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

1 Reply

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