Introduction:When you use "Move & copy" function khổng lồ copy Sheet on Excel file. You receive a message from Microsoft Excel with nội dung as below:"A formula or sheet you want to move or copy contains the name "tệp tin name", which already exists on the destination worksheet. Do you want lớn use this version of the name?To use the name as defined in the destination sheet, click yes. To rename the range referred to lớn in the formula or worksheet, cliông xã no, and enter a new name in the Nme Confilct dialog box."

*
When you choose "Yes", this message is still not lost. When you choose "No", a message windows with name "Name Conflict" that will aprrears:"Name already exists on destination sheet.Old Name:...New name:..."


*

You can not cthua this Name Conflict message, even if you fill any information at "Old name" & "New name" cell or choose Cancel.

Bạn đang xem: "a formula or sheet you want to move or copy contains the name

This is a classic error in Excel. When this is the case, you can not open, modify & close to any Excel tệp tin.Don"t worry, QTit will help you fix this error with some basic step.

You can see đoạn phim guide for fix error: Name conflict in Excel


How to lớn Do:
Step 1: The first, you turn off this message by: Mouse right Taskbar > Task Manager > Process tab > Right mouse Microsoft Excel > End task.


*

*

*

Step 2: Install and open the program XLStyles Tool (this program is only supported on Windows 10)

*

Step 3: Clichồng Get File > find and select the path of the corrupted Excel file > select Remove sầu All in Name Ranges With External References > Process File


*


Step 4: Open the corrupted Excel tệp tin. Select the Formulas tab > Name Manager.

*

Step 5: Select all values in the Name Manager table. & Delete (delete them).

*

Step 6: Completed. Please open the error excel tệp tin & kiểm tra it. I"m 100% successful for sure.

Xem thêm: Cách Nấu Cháo Yến Mạch Với Sữa Tươi Đơn Giản Và Dễ Làm Trong Quá Trình Ăn Dặm

So you already fixed error: Name Conflict In ExcelConclusion:This is a general formula that QTit has learned from experience khổng lồ fix this classic Name Conflict error in Excel. Thank you for reading QTit"s article.