Feedback by UserVoice

 

Ricardo Diaz

← Welcome to Excel’s Suggestion Box!

My feedback

  1. Add an If_NA optional sixth argument to XLOOKUP

    107 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

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

    Thanks for the suggestions folks! We will be adding [if_not_found] as the 6th argument to XLOOKUP. The thinking is as follows:

    • It’s a reasonably common use case
    • The ISNA XLOOKUP approach cannot distinguish a “not found” from a #N/A returned from a valid match.

    - Joe McDaid [Excel]

    Ricardo Diaz supported this idea  · 

  2. Add "Edit Measure" to right-click context menu for PivotTable Fields Values Pane

    9 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) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    Ricardo Diaz supported this idea  · 

  3. Fix DocumentLibraryVersions VBA

    1 vote
    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)  ·  Flag idea as inappropriate…  ·  Admin →
    Ricardo Diaz shared this idea  · 

  4. Maintain leading zeroes when entering values in cells

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

    87 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]

    Ricardo Diaz supported this idea  · 

  5. COUNT.DISTINCT Values

    58 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) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Ricardo Diaz supported this idea  · 

  6. Convert Dynamic Arrays into Tables

    68 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

    11 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Ricardo Diaz supported this idea  · 

  7. Power Pivot allow drill down to more than 1000 rows

    9 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) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    Ricardo Diaz supported this idea  · 

  8. Add cell reference to Data Validation Messages (Input Message, Error Alert)

    35 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) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Ricardo Diaz supported this idea  · 

  9. Default the Power Query formula bar as on

    59 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 →
    Ricardo Diaz supported this idea  · 

  10. When copying tabs, somtimes we have to cycle through 100s of "Yes" or "No" to the "Name already exists warning" Can we add Yes to All option

    210 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

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

    Good news! We have released a few fixes to Insiders to address this issue. If you are on Insiders, please let us know if the fix has worked for you.

    The fixes should be in build 11809.10000 and onwards.

    -Joe McDaid [Excel Team]

    Ricardo Diaz supported this idea  · 

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

    117 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 →
    Ricardo Diaz supported this idea  · 

  12. Add Center Across Selection to the Merge & Center Drop-down

    516 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

    81 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Ricardo Diaz supported this idea  · 

  13. Include Mailbox archive access when connecting to Exchange via Power Query

    6 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) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Ricardo Diaz supported this idea  · 

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

    999 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

    162 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

    Ricardo Diaz commented  · 

    Hi Ashvini Sharma, any updates on this front?

    Ricardo Diaz commented  · 

    As a power user, you can find an alternative in VBA, but this is a common scenario in business.

    Ricardo Diaz supported this idea  · 

  15. Improve Queries and Connections Task Pane

    30 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) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Ricardo Diaz commented  · 

    Another one: Show the last elpased time it took each query to refresh

    Ricardo Diaz supported this idea  · 

  16. Load Tables as separate queries into Power Query Editor in one step

    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

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

  17. Linking chart title to a cell on waterfall charts.

    31 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) » Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  Scott Ruble (PM MSFT) responded

    This capability is not currently supported on any of our new chart types in O16. However, we are working on plans to support this functionality in the future.

    Thanks,
    Scott [MSFT]

    Ricardo Diaz commented  · 

    Looking forward for this to be fixed in 2019 version

    Ricardo Diaz supported this idea  · 

  18. Add a Reporting Ribbon to Excel to consolidate and highlight the amazing capabilities of Power Query and Power Pivot

    246 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

    26 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Ricardo Diaz supported this idea  · 

  19. Show Tables in Power Query when opening an xlsb file

    53 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

    14 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Ricardo Diaz supported this idea  · 

  20. Add "Run R Script" option to Excel 2016 and Excel 2013 "Power Query" add-in, as it is for Power BI.

    244 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

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

    Hi folks,

    Thanks for your passion around this. We’ve been discussing this item off and on for some time now and we’d love to get your input.

    The reason we’ve resisted this is because the R runtime & various packages (and updating their versions) aren’t straightforward for other users to install. This limits sharing such queries across a workgroup.

    What do you think?

    For others reading this that’d like us to prioritize this work, please be sure to add your vote since we’re prioritizing our backlog based on these.

    thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    Ricardo Diaz supported this idea  · 
← Previous 1 3

Feedback and Knowledge Base

(thinking…)