What to do if excel name conflict cannot be closed

The solution to excel name conflict that cannot be closed: first open the VB macro editor; then add the code as "Sub ShowAllNames()" and press F5 to run; then delete the code, save it and close the macro editor; finally Just reopen the "Name Manager" and save the Excel file.

Recommended: "Excel Tutorial"

Open the VB macro editor (Atl F11 or record a macro- Edit macro (open the editor) and paste the following code in:

Sub ShowAllNames()
For Each n In ThisWorkbook.Names
n.Visible = True
Next
End Sub

F5 to run. After successful operation, you can delete the code, save it, close the macro editor and return to Excel.

Reopen the "Name Manager" and you can see all the names.

If you think it is unnecessary, just delete it directly.

Save the Excel file and the problem is solved.

The above is the detailed content of What to do if excel name conflict cannot be closed. For more information, please follow other related articles on the PHP Chinese website!