When copying tabs, somtimes we have to cycle through 100s of "Yes" or "No" to the "Name already exists warning" Can we add Yes to All option
This is a major productivity killer for power users such as finance teams, and current UX does not help exit this state efficiently.

Thanx for all your feedback and voting folks!
You should see a “Yes to All” option in the “Name Conflict Dialog” from O365 version 1907 onwards. https://docs.microsoft.com/en-us/officeupdates/monthly-channel-2019#version-1907-july-29
Also, the “Name Conflict Dialog” article have been updated accordingly: https://support.office.com/en-us/article/why-am-i-seeing-the-name-conflict-dialog-box-in-excel-f9251985-dbde-4030-86d8-e90775e79952
Please let us know if you do not find this to be the case.
thanx,
Prash
[Excel Team]
29 comments
-
Anonymous commented
que hago si me dice que no hay espacio suficiente en memoria?
-
Anonymous commented
Thanks a ton Excel Team . . . love to see user feedback resulting in improvements.
-
Ewald commented
There's definitely a huge lack of assitance for advances users dealing with features like named ranges, conditional formatting, etc.
The best solution to overcome the mentioned problem might be a merge function for combining two workbooks, with automatic renaming (with user-specified prefix or suffix) for named ranges and worksheets. After merging, the user could delete what he doesn't need.
Of course, also on deleting parts of a workbook, I'd expect a warning before named ranged (in use) would get compromised. -
Wyn Hopkins commented
For those of you experiencing this, my video here explains one of the causes and how to avoid it...
https://youtu.be/eNmfHsBIyIY -
Alex Jamaica commented
I ******* hate that issue
-
Simon Adams commented
This feature is useless and annoying. There must be a better way of doing this.
-
James Bate commented
Please simply add a "cancel,do not copy tab" button. Seriously, the delays could really set me back on hard deadlines.
-
James Bate commented
This is the worst. Why is there not a way to click cancel. I have a very similar issue whenever I want to duplicate a spreadsheet (tab) with tuns of named cells and ranges into spreadsheet. I need to rename all the ranges/cells individually, or I'm prompted with a follow up dialog box. If I select the wrong spreadsheet to duplicate, I could be really screwed and severely delayed with respect to other work I need to achieve.
-
Simon Adams commented
This is so annoying. Once you are in the loop, you cannot exit. And it never makes any difference to the Excel sheet.
-
Hakan Yılmaz commented
Better to have a dialog box showing the differences between defined names in target and source workbooks, so we can set all at once and proceed.
-
Anonymous commented
This happens all the time and is extremely annoying!
-
Mc Fly commented
Go for it!!!
-
Anonymous commented
Absolutely agree that this needs to be fixed.
-
Malcolm commented
Totally agree with this. Extremely tedious.
-
[Deleted User] commented
AND a "No to all" choice.
-
Anonymous commented
absolutely need this. you can also delete all the names in name manager for preventing pop ups like this as a temporary solution.
-
Emre commented
yes pls, I think 99% of excel users will love this functionality !!!
-
Firdosh Daruwala commented
Definitely a time killer and am supportive to have this fixed
-
Anonymous commented
It would be much more productive if we could select all at once instead of going one by one. Please fix!
-
Anonymous commented
this is a decade old software bug