Feedback by UserVoice

Kenneth Barber

My feedback

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

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  2. 46 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  3. 29 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
    Kenneth Barber commented  · 

    The multi-select feature is already available in Excel 2016. It's an extra icon beside the filter on the Slicer. Or did you mean that multiselect should be incorporated into the search somehow?

    Also, if you have several hundred possible selections in a single Slicer, you could avoid some searching if you can somehow group those selections. For example, if you have a list of a few hundred countries, then in the source table, add a field for the continent and add a Slicer for that.

    If your source table (Table1) has repeated countries, then you will need another table (Table2) that maps continents to a unique list of countries. Then use INDEX(Table2[Continent],MATCH([@Country],Table2[Country],0)) in the continent column of Table1 to get the continent listed in Table2.

  4. 19 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    I thought that the default is Sum for numeric columns and Count for text?

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

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
    Kenneth Barber commented  · 

    Scott, can I do anything with that bug number or did you just write it here for internal use?

    Kenneth Barber shared this idea  · 
  6. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    You are right, Jeffrey. These days, I use the disconnected slicer and base my PivotTables on the Power Pivot Data Model. This suggestion can be declined.

    Kenneth Barber shared this idea  · 
  7. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    I cannot delete my suggestion when it has comments or votes from other people. Instead, it shows as "Anonymous". Please decline this suggestion. I don't see it ever happening.

  8. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    In response to Bryon, the workaround is to add a named range that refers to the table column, and then use that named range as the source of the data validation dropdown lists. Then you will have a dynamic dropdown list and the table can be on any sheet.

    Kenneth Barber supported this idea  · 
    Kenneth Barber shared this idea  · 
  9. 30 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Interesting idea. We’ll consider this in the next round of feature planning. In the meantime, please continue to vote on this idea.

    Thanks,
    Scott [MSFT]

    Kenneth Barber supported this idea  · 
    Kenneth Barber shared this idea  · 
  10. 12 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    There is even less excuse to not have this function now that array formulas are getting even easier thanks to dynamic arrays.

    Kenneth Barber supported this idea  · 
    Kenneth Barber commented  · 

    Charles, we already have the JOIN functionality with TEXTJOIN. All we need is SPLIT.

    Kenneth Barber commented  · 

    And it's already supported in FormulaDesk...

    Kenneth Barber shared this idea  · 
  11. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    This issue is fixed for data validation but not for form controls.

    Kenneth Barber supported this idea  · 
    Kenneth Barber commented  · 
    Kenneth Barber shared 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

    Kenneth Barber commented  · 

    I'm starting to realize that this might get messy very fast.

    Kenneth Barber shared this idea  · 
  13. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    The workaround seems to be this:

    If you have this code:
    With Application
    .ScreenUpdating = True 'Turn on screen updating…
    .ScreenUpdating = False '…and then immediately turn it back off
    End With

    Then replace it with this:
    With Application
    DoEvents
    .ScreenUpdating = True 'Turn on screen updating…
    DoEvents
    .ScreenUpdating = True 'This seems to be necessary for Excel 2016 and higher
    DoEvents
    .ScreenUpdating = False '…and then immediately turn it back off
    DoEvents
    End With

    You might need to call the above code twice to get it to work properly, and even then, the screen updating is still choppier than in Excel 2010.

    Kenneth Barber supported this idea  · 
    Kenneth Barber shared this idea  · 
  14. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
    Kenneth Barber commented  · 

    The File > Options method of changing the background and theme should be similar to that in File > Account.

    Kenneth Barber shared this idea  · 
  15. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    VBA is a bit different. The And and Or operators in VBA are bitwise and not Boolean, so you would need to be sure that these operators are used only on Boolean values before you attempt to short-circuit them.

    Kenneth Barber supported this idea  · 
    Kenneth Barber shared this idea  · 
  16. 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 →
    Kenneth Barber supported this idea  · 
    Kenneth Barber shared this idea  · 
  17. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
    Kenneth Barber shared this idea  · 
  18. 6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    After I saw that SINGLE got replaced with @, I think that it might be more appropriate to replace the union and intersection operators with functions, rather than have both the operators and functions available side-by-side.

    Kenneth Barber supported this idea  · 
    Kenneth Barber shared this idea  · 
  19. 6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
    Kenneth Barber shared this idea  · 
  20. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    Please mark this idea as completed. This is not an issue in later versions of Excel.

    Kenneth Barber supported this idea  · 
    Kenneth Barber shared this idea  · 

Feedback and Knowledge Base