Feedback by UserVoice

 

Anonymous

← Welcome to Excel’s Suggestion Box!

My feedback

  1. Dynamic Array Function Suggestions

    2 votes
    Sign in
    (thinking…)
    Password icon
    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 →
    Anonymous commented  · 

    The proposed modification to the UNIQUE function and the addition of DISTINCT and TOPN are natural feedback suggestions with respect to the new and unreleased Dynamic Array functionality.

    Anonymous shared this idea  · 

  2. Protect me from #REF! ambushes

    89 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    5 comments  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 

  3. Remove the pointless message “There's a problem with the clipboard, but you can still paste your content within this workbook."

    115 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    89 comments  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 

  4. Conditional formatting in charts

    120 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    15 comments  ·  Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  Scott Ruble (PM MSFT) responded

    Good idea. We are definitely considering chart conditional formatting for a future release. Please continue to vote on it.

    However, could you further elaborate on what you mean by “the value or content of the data labels”? Is the following scenario what you are looking for?

    Scenario
    Create a column chart that shows sales for various stores. (Sales on Y axis, Stores on X Axis.) Use color to represent the profitability of each store. Profit is a numerical value. (Bars in the chart show a gradient fill from green to red where green is high profit and red is low profit.)

    Thanks,
    Scott [MSFT]

    Anonymous commented  · 

    Folks, there's nothing happening in Excel Chart development. It appears that Power BI visuals will be the new charts in Excel.

  5. Auto resizing of formula bar

    125 votes
    Sign in
    (thinking…)
    Password icon
    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 →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Thanks for the suggestion. I think I’ve seen some related requests, I’ll look at merging them to make sure the votes properly reflect the ask. We’ll prioritize this into the execution pipe appropriately based on the number of votes.

    Cheers,
    John [MS XL]

    Anonymous supported this idea  · 

  6. Unhide multiple worksheets at once

    133 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

  7. Two new =if's

    165 votes
    Sign in
    (thinking…)
    Password icon
    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 →
    Anonymous supported this idea  · 

  8. Workbook level calculation

    176 votes
    Sign in
    (thinking…)
    Password icon
    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 →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Thanks for the post Charles, and for the in person conversation at the latest MVP conference. We definitely understand the ask and will keep our eye on it – it looks like it’s moving up the vote charts pretty quickly. As always, keep upvoting the things you are about most.

    Best,
    John [MS XL]

    Anonymous supported this idea  · 

  9. update VBA

    201 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    13 comments  ·  Excel for Windows (Desktop Application) » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous commented  · 

    VBA is too ancient to waste any development time on improving it. At one time, I was sure that it would be upgraded to VSTA (with an appropriate PIA to speak to Excel), but that has never happened. With cloud computing coming into the picture, we need a replacement language that can work on all platforms, and that language might be JavaScript.

  10. R in Excel (RRO + MKL as scripting language in Excel)

    143 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    21 comments  ·  Excel for Windows (Desktop Application) » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  Ashvini Sharma (Lead Program Manager, Microsoft) responded

    Hi all,

    Yes, we’re considering providing R integration with Excel in the future, the number of votes on this item helps us gauge overall community interest in this, so please pull in others if you think they’d like this as well.

    regards
    ash [MS XL]

    Anonymous commented  · 

    "Yes, we’re considering providing R integration with Excel in the future"

    You're actually considering this? We can't even get the R.Execute function in Power Query, although it's just a matter of enabling the function.

    Anonymous supported this idea  · 

  11. Allow interaction with Excel while in Power Query

    213 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

    Makes no sense at all. After all, with Power Pivot, you can easily switch between Excel and the Power Pivot window. You can't even use another workbook while in the Power Query editor.

    Anonymous supported this idea  · 

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

    208 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    28 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

    Anonymous commented  · 

    "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."

    Since so many Microsoft apps support Open R, R should be installed and managed in one location on every desktop. The installation can be done by Windows, Office 365, Power BI, SQL Server, whatever. When an app is run, it checks for the install and version, and install/update as necessary (including packages). For the Microsoft apps that support R, other instances of R installed elsewhere should be ignored.

    Anonymous supported this idea  · 
    Anonymous commented  · 

    "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"

    Hi Ash,

    Perhaps R Open and associated packages should be installed with Office 365. Updates can be part of Office 365 updates. Then you can add the R.Execute function to M in Excel, which would allow folks to build cross-platform solutions using M & R.

  13. Be able to protect Power Query with password

    237 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

    Hi Joana & others,

    Thanks for logging this suggestion. Yes, being able to protect your queries would be quite useful indeed for delivering solutions. We’ll prioritize this based on the interest, so if you’re reading this and haven’t voted as yet, please do so.

    thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    Anonymous supported this idea  · 

  14. Built-in RegEx / Regular Expressions Functions to Search, Extract, and Replace

    382 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

  15. Conditional formatting - Apply to named ranges

    615 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

    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)

    Anonymous supported this idea  · 

  16. Give us a proper NULL() worksheet function.

    612 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

    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]

    Anonymous supported this idea  · 

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

    701 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

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

    Thanks for the suggestion Wyn! Thanks also to all the contributors to this thread for the thoughtful discussion and debate.

    Of the many lookup function requests, this is currently one of the highest ranking on UserVoice. Please keep the votes rolling in if you’d like to see this, it helps us prioritize new feature work.

    JoeMcD [MS XL]

    Anonymous supported this idea  · 

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

    768 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    124 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

    Anonymous supported this idea  · 

  19. Horizontal Box and Whisker Plots

    4 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
    Anonymous supported this idea  · 

  20. Add Dividend Data to Stock Data Type

    18 votes
    Sign in
    (thinking…)
    Password icon
    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 →
    Anonymous supported this idea  · 
← Previous 1

Feedback and Knowledge Base

(thinking…)