How to avoid warning windows pop up in Excel

How to avoid windows pop up in Excel when I do copy work sheet?

Every time I do copy worksheet , there will have this pop up windows happens always.
I have to click YES for many times until I can have new worksheet.

If there is any method to avoid warning windows pop up? It’s annoying. ><

Here is picture for Question Excel_how to avoid pop up when copy sheet.jpg

Thanks a lot in advance,
WRBLEE

You can copy worksheet by right click on sheet name
choose Move or copy
check box Create a copy
OK

Then you won't have any questions.

Dear zbor,

I did what you advise before but there is still have this problem. I think it's related about formula or not?

I even try to create new file and make new worksheet, then I copy it by right click. It's ok for a first few sheets.

But it has this warning for next worksheets.
"The formula or sheet you want to copy contains the name"Excel_BuiltIn_PrintArea_xx", which already exist on the destination worksheet.
Do you want to use this version of the name?
- To work the name as defined in the destination sheet , click "YES" >>> Which I got to keep pressing YES until there is new worksheet created.
- To rename the range referred to in the formula or worksheet, click "NO" and enter the new name in the name conflict dialog box.
>>When I click "NO" , Then another window of "Name Conflict" pop up and I have to refill new name of the area, which I don't have any idea what the new name I got to fill?

I have upload excel file as attached....pls kindly advise.

ANSWER_121022_question excel.xlsx

Thanks in advance...