Name already exist error in excel

Hi. 

I have been working on a Excel sheet for work. 

The idea is to have one sheet and create a copy this same sheet in the same workbook as many times needed. 

The name "YYY" already exists. Click Yes to use that version of the name, or click No to rename the version of "YYY" you're moving or copying. 

I get it 10 times. If I click YES to all of them I can create the copy and keep working. 

I have read in the forums in regards this error and i found that we have to delete all the names existing in the name manager and i did it but still am getting the same problem  

Could I please have some feedback on how to remove this message every time i want to create a new copy? 

I will appreciate your help, since I haven't been able how to solve it. 

THANK YOU

ADITYA

Delete the old name and re-create it, but use the sheet as scope (not the workbook).

Andreas.

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Still not solved

6 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

If you do not do what I say you will not find a solution, okay?

Try in a new file:

Open the Name Manager
Click New

Write a name and use the sheet as scope.

Ok, Close

Now copy the sheet as many times you like, no errors. .-)

Andreas.

16 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 13, 2025 Views 18,567 Applies to: