Feedback by UserVoice

Kevin Osborn

My feedback

  1. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  2. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kevin Osborn commented  · 

    Agree and voted it up. That said, the workaround is to create a named range in cell A1 (or whatever cell you want) within each sheet and then hyperlink to the named range instead of the sheet.

    Kevin Osborn supported this idea  · 
  3. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  4. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  5. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kevin Osborn commented  · 

    Try custom format ;;; which will display nothing regardless of the text or cell color.

  6. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  7. 243 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kevin Osborn commented  · 

    Microsoft ... time to take this one to a vote. It's buried being 5 years old but it's a serious issue. No reason in 2020 that the user cannot start typing and have the data validation list open and go to the first combination of the characters entered.

    ps. And allow Tab to select the item and move to the the next cell. Don't force the user to only select the item using the Enter key.

    Kevin Osborn supported this idea  · 
  8. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kevin Osborn commented  · 

    @Harlan Grove ... you have a good point with respect to your example where one formula refers to 2 cells and you cut one cell and paste into the other.

    I run into this problem all the time as it relates to tables. It's not related to cut/paste but frequently a column or whole table is deleted. Frequently it's related to Power Query where the PQ changes and thus the output table changes. Here is what happens and why this is so frustrating.

    A1 = XLOOKUP("ABC",Table1[Column1],Table1[Column2]). Column 2 disappears for some reason (see above) and Excel now shows A1 = XLOOKUP("ABC",Table1[Column1],#REF!). So it is impossible to look at A1 and know what was intended in the formula. If the formula was left as it was originally and the result was #REF then it would be easy to find the problem and fix it.

    I would be ok if Excel provided a warning IFF (if and ONLY if) the warning was not generic and actually told the user what cells and formulas were going to be affected and the message could be copied to the clipboard or provided in a new sheet (e.g. Check Compatibility > Copy to New Sheet). There are too many cases (e.g. Links, Pivot Tables) where Excel provides a message (e.g. broken links) but does not provide a way to find what was broken.

    Kevin Osborn supported this idea  · 
  9. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  10. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  11. 492 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  12. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  13. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  14. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kevin Osborn commented  · 

    To do this you can use the UNIQUE function.

    A1 = UNIQUE(B1:B10). Then in your data validation select list and assign it to =A1#.

    That said this requires a spilled array created just for this purpose so I like you concept of a checkbox added when "select from list" is selected for Unique. It would also be nice to have a similar checkbox to "ignore blank in list" to not show a blank value if blank exists in the list.

    Kevin Osborn supported this idea  · 
  15. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  16. 13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  17. 13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
  18. 16 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Kevin Osborn commented  · 

    This is a real problem. RefreshAll via VBA should return the same errors to the user that clicking RefreshAll via the data ribbon does.

    Kevin Osborn supported this idea  · 
  19. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Kevin Osborn commented  · 

    Totally agree Ivan and was about to enter the exact same request when I saw yours. And concur that there needs to be an input of version with which to compare as opposed to way it works now where it compares against everything and you uncheck versions you don't want it to compare/show.

    Compatibility checker also needs to be smart enough to understand if a function that could return an array does not (i.e. it only returns a single value) that it not be flagged as a comparability issue for versions without the new calc engine. For example, =COLUMN(Table1[Column1]) will be flagged as a compatibility issue but this does not return an array as only 1 column is referenced.

    This is absolutely necessary now that releases can occur monthly with new functions.

    One additional request. There should be a Mac/Windows checkbox such that the compatibility checker will check against Mac versions as well (if currently in windows) and against Windows (if currently in Mac).

    Kevin Osborn supported this idea  · 
  20. 15 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kevin Osborn supported this idea  · 
← Previous 1 3 4 5

Feedback and Knowledge Base