Feedback by UserVoice

Malcolm

My feedback

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

    We’ll send you updates on this idea

    Thanks for the feedback! We’re seeing a number of different posts about lookup functions – we’ll be taking a close look at this area and thinking it through. We’ll prioritize the asks according to votes along with other requests on the site. So I encourage people to keep voting if it’s something they really want to see the priority raised on.

    Best,
    John [MS XL]

    An error occurred while saving the comment
    Malcolm commented  · 

    XLOOKUP is good. Thanks for that.

  2. 590 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
    Malcolm commented  · 

    Still waiting for this after two years and wondering why it is so difficult to implement. We've got Regex in VBA after all, so most of the parsing code must be there and ready to re-use.

    We've had a lot of other changes to Excel in those two years - many of which don't appear to have been requested by users (at least judging by this forum) but we are still awaiting some of the more requested ones here!

    Malcolm supported this idea  · 
  3. 538 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
    Malcolm commented  · 

    Over two years and we still don't have this. It's still back in the dark ages for this where you could only run one program at a time. Screenshots or handwritten notes really should not be needed in this day and age but it is the only way of seeing the data file and the query at the same time!

    Malcolm supported this idea  · 
    An error occurred while saving the comment
    Malcolm commented  · 

    I agree: it slows down work considerably having to keep quitting the query to check the underlying data.

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

    We’ll send you updates on this idea

    Great suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.

    Thanks,
    John [MS XL]

    An error occurred while saving the comment
    Malcolm commented  · 

    It should interface properly with Power Pivot which does have a null type, please.

    Malcolm supported this idea  · 
  5. 909 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks to Graham for starting this conversation. If you would also like Excel to maintain named range references and structured table references in the “applies to” field for Conditional Formatting rules, please add your comments and vote this one up. We will prioritize accordingly.

    Thanks,
    Steve (MS Excel)

    An error occurred while saving the comment
    Malcolm commented  · 

    I'm also finding that the most common reason Excel crashes and needs to repair a file is to do with conditional formats in tables. When "repaired" the conditional formats have been stripped out entirely. It only occurs in tables when there is a formula used to select the conditional format but it occurs so regularly for me that I now have macros in my spreadsheets that detect if a conditional format has "disappeared" and re-instates it!

    When looking at dealing with the named ranged issue, please can you also look to remove whatever bug causes these table-based conditional formats to crash Excel?

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

    We’ll send you updates on this idea

    Malcolm supported this idea  · 
    An error occurred while saving the comment
    Malcolm commented  · 

    As the person who you say "describes the mechanism best" I will definitely vote for this and thanks for summarising it all. The approach to headers and footers, even its appearance, shows that it has really not been thought about since the days Excel was first launched.

    It's something people have been asking to be approved for years and yet instead we get glossy new charts, "ideas" and such like which must be far more difficult to program and less useful to the wider audience.

    Come on Microsoft, bring headers and footers in to the late 20th century at least.

  7. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Malcolm shared this idea  · 
  8. 65 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
    Malcolm commented  · 

    Couldn't agree more. It has been a real productivity waster for years, having to reset the panes every time.

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

    We’ll send you updates on this idea

    Malcolm supported this idea  · 
  10. 1,360 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

    Thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    An error occurred while saving the comment
    Malcolm commented  · 

    Given that Power Pivot is becoming an ever more promoted part of Excel and Power Pivots and queries often depend in user input tables, it is absolutely mind-boggling surprising that this gross oversight has not been fixed.

    An error occurred while saving the comment
    Malcolm commented  · 

    Getting even more important now that Bi and get & transform are becoming an everyday tool. We critically need to be able to protect the cells around these tables whilst allowing rows and columns (don't forget pivot tables) to be added and deleted.

    Malcolm supported this idea  · 
  11. 10 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
    Malcolm commented  · 

    It has been suggested for a long time now that Excel introduces Regular Expressions into search and replace. This would solve the issue at a stroke as well as allowing for more flexibility throughout. It's all there in VBA already, how hard would it be to implement in the Search and Replace box?

  12. 65 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Malcolm shared this idea  · 
  16. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Malcolm shared this idea  · 
  17. 43 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Malcolm 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

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

    We’ll send you updates on this idea

    Malcolm shared this idea  · 
← Previous 1 3 4

Feedback and Knowledge Base