Conflicts Name A Cell Or Range. The new name will not be accepted if it. The reason you get the problem is that excel is trying to resolve a conflict between two range names.
To choose a different name click no and enter a new name in the name conflict dialog box. Here are the possible answers to the question posed. The reason you get the problem is that excel is trying to resolve a conflict between two range names.
Select a cell or a range of cells that you want to name.
The name box in excel is fastest way to create a named range. This displays the following dialog box. The range name called revenue in the revised workbook. The new name will not be accepted if it.