Best way to quit the Name Conflict loop in Excel 2016?

Does anyone know of a way to get out of this besides CTRL-ALT-DEL and stop the Excel process?

Somebody had this error and that's what they did with Excel 2007 (https://superuser.com/questions/3776...he-name-dialog), and that's what I had to do tonight with Excel 2016.

The way the dialog boxes go, even when you X, or cancel, or no, it won't let you stop the copy-and-paste operation, so you have to hard-stop Excel to move on.

I appreciate any help.

Regards,
leaning

AM6StringJazzer,

As it is, it's like "You are already using that name. Please enter a new name or we are going to overwrite that name with this duplicated names data."

Hmmm. What I'd really like to do is cancel this copy-and-paste operation and take a look at the Name Manager to see what's going on, but it doesn't let you. The dialog boxes keep the focus so you can't click on anything on the ribbon. I don't want to overwrite, and I'd rather not give it a name just so I can go back in later through the Name Manager and compare them.

So, since it won't let you back out, you have to C-A-D and hope that your autosave got all your recent work.

The fact that even two users feel they have to crash the program to get past this means that it's an area for improvement, I think.

Regards,
leaning

I would agree it's an area for improvement. I see the problem, although I have always just continued and then checked over the names afterwards.

To be clear, it is not overwriting data. Suppose you have a sheet with a named range TestMe and you have a formula that says something like =TestMe*2. If you paste this sheet into a file that already has a name TestMe, it is telling you that it the name exists and you can either have the formula refer to the name that's already in the file, or you can provide a new name for what you are pasting in.