Feedback by UserVoice

 

Ed Hansberry

← Welcome to Excel’s Suggestion Box!

My feedback

  1. Aggregate 2D arrays by row or by column (especially relevant to dynamic arrays)

    4 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

    2 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry supported this idea  · 

  2. XLOOKUP to return an array of ranges

    7 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

    5 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry commented  · 

    See this discussion in the Excel Tech Community for a specific example of what happens. https://techcommunity.microsoft.com/t5/excel-blog/announcing-xlookup/bc-p/830248/highlight/true#M708

    Attached workbook will show how this works.

    Ed Hansberry supported this idea  · 

  3. Release XLOOKUP to the world!

    90 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

    23 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry supported this idea  · 
    Ed Hansberry commented  · 

    XLOOKUP is now available to Insiders and Monthly Targeted users. Not sure when it will hit Monthly (hopefully soon), and I am sure Deferred/Semi-Annual is another 6 months out, as always. They are still testing which is why it isn't fully out in Office 365.

  4. Unhide multiple worksheets at once

    593 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

    57 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry supported this idea  · 

  5. Link workbook to an Access database to use Excel as front-end GUI.

    3 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

    4 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry commented  · 

    I wouldn't hold my breath on this. MS seems to be moving to Power Platform for this kind of thing, which does support Excel as a backend, and a front-end soon. Between Power Apps and Power BI, plus whatever data source you want, like CDS or on-prem sources like SQL server or even Access databases, all of the functionality you discuss is there, and much MUCH more.

    It seems they are removing features from Access, not adding. They will not add Power Query to it (that idea with well over 1K votes was rejected), Data Access Pages was killed, Pivot queries were killed, and the Access to SQL upsizing wizard was killed.

    They haven't officially said of course, but Access seems to only get nominal features to keep it on par with other Office 365 apps, but there are no real breakthrough features.

  6. Add Power BI Dataflows as a data source in "Get & Transform Data"

    88 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

    8 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry commented  · 

    FWIW, in the Office 365 Insiders build of Excel, Power Query has a "Power Platform" menu as a data source that is grayed out, and one of the members on the team said functionality was coming. I would hope that would include Power BI data sets, Data Flows, and CDS, just like it does on Power BI Desktop. I keep checking every week. It first showed up a month or so ago, or at least that was when I first noticed it. So it is coming....

    Ed Hansberry supported this idea  · 

  7. Improve the Conditional Formatting Manager

    300 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

    62 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Thanks for the suggestion Levi! We’ll be taking a look at this along with some other asks around conditional formatting. It’s a big help to see the things with the most votes, particularly within areas like formatting. So please keep the votes coming for things you want us to do sooner!

    Thanks,
    John [MS XL]

    Ed Hansberry supported this idea  · 

  8. Power Query Time Stamp of last updated Data

    16 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

    0 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry supported this idea  · 

  9. Get Tables working on protected sheets (add rows, sort, filter, etc.)

    1,072 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

    174 comments  ·  Excel for Windows (Desktop Application) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    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

    Ed Hansberry supported this idea  · 
    Ed Hansberry commented  · 

    Personally I think ms would like to see Access die. PowerQuery has replaced virtually all of our “read” queries and SharePoint lists, excel tables and even SQL Express are easy to use. 2 years ago ms started giving access to all office pro licenses in 365. They seem to no longer consider it a premium product.

  10. Bring Power Pivot closer to Power BI Desktop Functionality

    43 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

    3 comments  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry shared this idea  · 

  11. Make a simple safer version of VLOOKUP and INDEX MATCH

    746 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

    125 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry commented  · 

    @roy, FWIW, the dynamic array functions started rolling out to the Monthly Targeted users, which is the old "Insider Slow" ring. So it is far enough along they are doing broad tests with people that have their tenants or personal builds set to a faster update cadence. Still don't know when it will hit the normal Monthly build.

    But it is out of a pure "Insider Fast" ring now, so it is moving!

    I am on the insider builds, and it still took about 2-3 weeks to get the dynamic array functions last year after the announcement. This time I got XLOOKUP/XMATCH day one. I think these are less complex to manage, but they do some spilling themselves, so are probably dependent on the new DA calc engine somewhat.

    Ed Hansberry supported this idea  · 

  12. Allow formulas to be formatted and editted like code in the formula dialog box

    5 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

    1 comment  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry supported this idea  · 

  13. Add 'date picker' to enable users to select a date from a mini calendar into cells

    1,299 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

    1010 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Hi all,

    We have been working on this, and wanted to get your feedback on how you see this feature fitting into your workflow. We have a quick one question survey for you to give us your thoughts on the look and keyboard shortcuts we have at this time. Please see here for more: aka.ms/datePickerSurvey

    Thanks!
    Blake, Excel Product Team

    Ed Hansberry supported this idea  · 

  14. Maintain leading zeroes when entering values in cells

    1,413 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

    90 comments  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Thanks very much for your votes. And to those who took the time to fill in the survey, thank you! This is a brief update to let y’all know that we’ve started work on this feature request along with the one on changing numbers to scientific notation.

    - Urmi [Msft]

    Ed Hansberry supported this idea  · 

  15. Have Excel scroll better when there are large cells.

    2,527 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

    673 comments  ·  Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  Eric Patterson (Program Mgr - MSFT) responded

    Thanks everyone for all of the passion about this suggestion! The number of votes has increased greatly in the last couple months and we’re taking notice! We’ve got a bunch of other Excel endpoints behaving this way already and we’re evaluating getting it done in the Windows versions sooner based on the number of votes it gets – so keep the votes coming!

    Eric Patterson (Program Manager – MSFT)

    Ed Hansberry supported this idea  · 

  16. Python as an Excel scripting language

    6,325 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

    441 comments  ·  Excel for Windows (Desktop Application) » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Wow.

    Thank you to all those participated in our survey. What an amazing number of responses, many of them with very deep content. We’re processing the over ten thousand responses(!), and already appreciate the time so many of you took to answer with passion and experience.

    Please know this survey is used to help influence various topics – both on Python as well as other related topics that the comments started to bleed into. Given the passion, I want to be clear this remains an area of exploration for us, without any specific timeline.

    We’ll provide updates as we progress on this feature request.

    Thanks!

    Ashvini Sharma
    Lead Program Manager
    Excel

    Ed Hansberry supported this idea  · 

  17. COUNT.DISTINCT Values

    62 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

    7 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry commented  · 

    @sergie - Mac, iOS, and iPadOS all have Dynamic Array functions for Insiders. Not sure about Android, but it will if it doesn't now.

  18. Default the Power Query formula bar as on

    62 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

    6 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry supported this idea  · 
    Ed Hansberry commented  · 

    Has anyone tried this lately? I opened Excel on a PC I am 99% sure I haven't used PQ on and formula bar was showing. It was the 1906 Monthly Targeted build.

  19. Make Conditional Formatting Rules Editor window sizable.

    121 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

    10 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry supported this idea  · 

  20. Tables should default to "My table has headers" being ticked

    125 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

    10 comments  ·  Excel for Windows (Desktop Application) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry supported this idea  · 
← Previous 1 3 4

Feedback and Knowledge Base

(thinking…)