Feedback by UserVoice

 

How can we improve Excel for Windows (Desktop Application)?

← Excel for Windows (Desktop Application)

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.

231 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
completed  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded  · 

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]

Show previous admin responses (1)

29 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Ewald commented  ·   ·  Flag as inappropriate

    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.

  • James Bate commented  ·   ·  Flag as inappropriate

    Please simply add a "cancel,do not copy tab" button. Seriously, the delays could really set me back on hard deadlines.

  • James Bate commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    yes pls, I think 99% of excel users will love this functionality !!!

  • Anonymous commented  ·   ·  Flag as inappropriate

    It would be much more productive if we could select all at once instead of going one by one. Please fix!

← Previous 1

Excel for Windows (Desktop Application): Performance

Categories

Feedback and Knowledge Base

(thinking…)