Feedback by UserVoice

Anonymous

My feedback

  1. 14 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous commented  · 

    Improving the usefulness of error messages in general would be a very worthwhile investment in Excel. I know its not the **** stuff you get to tout at conferences. But just announcing to the user that somewhere (won't say where) there's a problem just sends us on a hunt that could be resolved faster with more specific details.

    Anonymous supported this idea  · 
  2. 2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous supported this idea  · 
    Anonymous commented  · 

    I would like to have a collection of capitalized words in my personal dictionary that are allowed to survive PROPER conversion tin uppercase.
    It's a lot of work to clean up all the acronyms embedded in text. Chances are good that if "USD" occurs in my text as an entire word (not a word segment) I don't want it to be converted to "Usd". A way to exclude those from conversion or specify my preferred case for that word ("SharePoint") would be a huge timesaver.

    Anonymous commented  · 

    PROPER() should only capitalize the FIRST character in the word. 195Th shouldn't happen.
    But neither should 3M or 1Direction or 404L
    I can't think of a reason to uppercase midword characters using PROPER().

    I can write my own user-defined function to correct the 10 digits and their suffixes. But that's English specific. Excel is a global tool. So just making the FIRST character uppercase would be a good fix by Microsoft with a switch for the few who somehow enjoy having the first occurring alpha character in uppercase.

    1st
    2nd
    3rd
    4th
    5th
    6th
    7th
    8th
    9th
    0th

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

    We’ll send you updates on this idea

    Anonymous commented  · 

    I would like to provide my users with a data table that is protected but has collapsible groups of columns to make it easy for them to expend to see details, hide again to narrow the table to a screen wide. I was surprised to find this was impossible to do when Protection was turned on.
    I am having to leave Protection off to offer tidy grouping.

    Anonymous supported this idea  · 
  4. 1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous shared this idea  · 
  5. 5 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous supported this idea  · 
    Anonymous commented  · 

    Another vote for keeping the Backstage truly "in the back" and not up front all the time.
    Very confusing to users.

  6. 13 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous commented  · 

    This is a great suggestion. But you can get it back by changing your settings now.
    File...Options...Save...check "Don't show the Backstage when opening or saving files" box.

    Save As will still go to the "Backstage" whatever-the-heck-all-that-is in case you want to wrestle with all that.

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

    We’ll send you updates on this idea

    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  · 

    A blog post mentioning R.Execute & Power Query got me all excited to use R to do things like unzipping a datafile as part of the script. But I quickly discovered that was for Power BI only, not Power Query in Excel. Shucks.

    Anonymous supported this idea  · 
  8. 213 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous supported this idea  · 
  9. 15 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous shared this idea  · 
  10. 237 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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 commented  · 

    For the record, I vote "no". If you can put a password on something, some people will ALWAYS do it. Even when it makes no sense. Like locking the restrooms. Don't do it.

    It's a feature to be able to let "any user" change Power Query connections. That's how they learn. If you need source data locked down, use appropriate security methods on back end to do it.

  11. 93 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous shared this idea  · 
  12. 39 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

  13. 815 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks again for all the passion on this issue – we hear you and we’ll get someone on the team to dig in to the issue. I’ve seen a few related sub-issues while scanning over the comment section for this one, so we may reach out to a few of you for clarifications. Thanks again for all the votes, and keep them coming for the issues you care about!

    John, Excel

    Anonymous supported this idea  · 
  14. 701 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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 commented  · 

    If you're looking up a value (A5) in the first column of a table (Table1) and want a particular column by name, this works. But its confusing to interpret.

    =VLOOKUP($A5,Table1[#All],MATCH("Product Description",Table1[#Headers],0),FALSE)

    A simpler function that takes the minimum # of parameters might be:

    =SCHLOOKUP($A5,Table1,"Product Description",FALSE)

    Even better, if this lookup is in column D, this formula could be copied down...and to other columns as long as same column names are used both tables:

    =SCHLOOKUP($A5,Table1,D$4,FALSE)

    I wouldn't mind something like this.
    Nice and short.

    Anonymous supported this idea  · 
  15. 401 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Hi Ken,

    Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

    thanks
    ash [MS XL]

    Anonymous supported this idea  · 
  16. 166 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous supported this idea  · 
  17. 141 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous supported this idea  · 

Feedback and Knowledge Base