Feedback by UserVoice

Kenneth Barber

My feedback

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

    We’ll send you updates on this idea

    This is great feedback. Supporting this feature is something we are actively discussing. Please continue to vote on this feature suggestion which will increase its likelihood of getting in the product.

    Thanks,
    Scott [MSFT]

  2. 13 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  · 
  3. 95 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 can see some problems with this already. As Andrew already pointed out, he wants COUNTDISTINCTIFS. I can see others wanting SUMDISTINCT or AVERAGEDISTINCT with IFS variants. That's just too many functions.

    I think that the UNIQUE function suggestion should be implemented instead:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9095341-create-function-unique-array-extracting-unique-va

    Then you can use COUNT or whatever function on that.

    For the IFS variants, we would need FILTER to be implemented:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10886142-array-saving-filter-function-to-replace-vlookup

    The downside of my suggestion is that you always need 2 functions, but the upside is that it's better long-term. Microsoft is only ever going to add functions to Excel, so we don't want future versions having a long list of functions that are slight variants of each other. It would be intimidating and painful to sift through.

  4. 11 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  · 

    Oh, and the reason why all of your files freeze is because they're open in the same instance of Excel. You can open a new instance of Excel by opening the Excel executable file again.

    Save often, my friend.

    Kenneth Barber commented  · 

    Hi Anonymous. It's probably just taking a very long time to calculate and is not actually frozen. See my post:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10781952-need-a-better-distinction-between-long-calculatio

    Now I will say this: I have seen Excel in a "not responding" state that it doesn't seem to get out of. It seems to occur when the memory usage exceeds about 1 GB (I don't know the exact cutoff). Just before that point, it might take 5 minutes to calculate, but slightly after that point, it can go on for much longer and doesn't seem to finish, suggesting that it's legit frozen. However, I don't have enough information to make it a formal suggestion. I was using Excel 2010, 32-bit.

    Anonymous, if your case fits the description that I just described, then could you upload your workbook for us all to see? Obviously, change any confidential information. Ideally, you would give us a just-barely-working workbook and then describe to us how we can make it "not responding". See my post for an example of this:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10720941-cannot-open-files-containing-large-dynamic-graphs

  5. 3 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  · 
    Kenneth Barber commented  · 

    What is so bad about the lines? They let you know which part will scroll and which part will not.

  6. 23 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  · 

    When you think about it, Freeze Panes is really just a restricted Split. The restrictions: Freeze Panes always starts at the edge of the sheet and you can't scroll within the frozen pane.

    Since they're so similar, Excel should just have Split, with the option to restrict scrolling. Then we just need to be able to split twice to achieve the "border" of frozen panes.

    Kenneth Barber commented  · 

    For a workaround, go to the View tab and click Split. Drag the dividers to their appropriate positions.

  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  · 

    What is that limit?

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

    We’ll send you updates on this idea

  9. 10 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  · 
  10. 13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

  11. 418 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  · 
    Kenneth Barber 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

    2 comments  ·  Excel for the web  ·  Flag idea as inappropriate…  ·  Admin →
    Kenneth Barber commented  · 
  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  · 

    You can always use Wrap Text on your length values and then adjust the row height back to normal.

  14. 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  · 

    Maybe you can upload a sample workbook that demonstrates this problem and link it here.

  15. 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  · 

    I like the match instance idea. Usually we only think about it as a possibility for VLOOKUP, not MATCH.

    Now to add to what Jeffrey said:
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10623393-vlookup-with-exact-match-and-sorted-data

  16. 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  · 

    I think you mean "Let us turn off the feature where double clicking on the edge of your selection moves your selection to the edge of the spreadsheet".

  17. 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  · 

    Where is the table in all of this?

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

    We’ll send you updates on this idea

    Interesting idea. Thanks for the feedback. We’ll consider this for a future release. Please continue to vote on this feature request which will increase its likelihood of getting in the product.

    Thanks,
    Scott [MSFT]

    Kenneth Barber commented  · 

    I think that such a feature would make a strong advertising point for the next version of Excel, given how visual it is. It's kind of hard to advertise some of the other suggestions (e.g. "VLOOKUP is better than before!" Yay? Doesn't seem to fit well in a commercial).

  19. 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  · 

    Title's a bit vague.

  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  · 

    Except that in Microsoft Word, the first words often aren't what you want to call your file. For example, my title within the document might be "Software Engineering Assignment 1", but I'll just call the file "Assignment 1" and keep it in my "Software Engineering" folder.

    For Excel, you usually have multiple sheets, and so unless you have a summary sheet, your file name won't come from any cell. Also consider how often you have to Save As--not much. If that's not your case, you're probably doing some sort of daily files, in which case you'd be better off keeping all of your daily data in 1 file. Things are easier when everything is in 1 place.

Feedback and Knowledge Base