Lỗi Name Conflict Trong Excel 2010

Excel for goldmarkcity-hanoi.com 365Excel 2019Excel 2016Excel 2013Excel 2010Excel 2007Excel Starter 2010More...Less

If you are seeing the Name Conflict dialog box in Excel, that"s because you are trying khổng lồ copy one or more worksheets to a workbook that has similar named ranges.

Bạn đang xem: Lỗi name conflict trong excel 2010

Suppose the worksheet that you"re trying to lớn copy và the destination workbook where you want to lớn copy the worksheet inkhổng lồ both have sầu a named range called InterestRates. When you try to move or copy the worksheet, Excel will detect this conflict and display the following message:

The name "InterestRates" already exists. Cliông xã Yes to lớn use that version of the name, or cliông chồng No lớn rename the version of "InterestRates" you"re moving or copying.


Note: The Name Conflict dialog box will appear for every instance of a conflicting name range. If you are using a subscription version of Excel then the conflict dialog message includes a third option labeled Yes lớn All which means you won"t see the message appear for additional conflicting name ranges.


Resolution

When you see the above sầu dialog box, you must vì one of the following:

Cliông chồng Yes to lớn continue using the conflicting range name in the destination workbook.

What happens when you cliông chồng Yes?

Excel will copy the conflicting name range lớn the destination workbook. That means you will have sầu two similarly named ranges in your destination workbook.


Warning: If there are formulas that refer lớn conflicting named ranges in your workbook, then copying those ranges will affect those formulas và cause errors in the workbook. If you are not familiar with the data in the destination workbook, bởi vì not cliông chồng Yes. Instead clichồng No lớn rename the conflicting range.


Cliông chồng Yes khổng lồ All to lớn continue using all possible conflicting range names in the destination workbook. chú ý that you only see this option if you"re using a subscription version of Excel.

Xem thêm: Parsley Là Rau Mùi Tây Là Gì ? 8 Tác Dụng Của Rau Mùi Tây Cây Rau Mùi Tây

What happens when you clichồng Yes lớn All?

Excel will copy all conflicting name ranges to lớn the destination workbook. That means you will have two or more similarly named ranges in your destination workbook.


Warning: If there are formulas that refer to conflicting named ranges in your workbook, then copying those ranges will affect those formulas và cause errors in the workbook. If you are not familiar with the data in the destination workbook, bởi vì not click Yes to lớn All. Instead cliông chồng No khổng lồ rename the conflicting ranges one by one.


Cliông xã No lớn rename the conflicting name range. This displays the following dialog box.

*

In the New name section, enter a new name for the range. The new name will not be accepted if it

starts with a letter or underscore,

is a cell reference, such as A1, A123, or XFD21,

has spaces or characters (, /, *, <, >, :, ?), or

has the same name as another range in the workbook that you are copying to lớn.

Cliông xã OK.

Need more help?

You can always ask an expert in the Excel Tech Community or get goldmarkcity-hanoi.com in the Answers community.

See Also

Define and use names in formulas


*

*
*
*

Great! Any other feedback? The more you tell us, the more we can help.How can we improve? The more you tell us, the more we can help.