Feedback by UserVoice

Anonymous

My feedback

  1. 12 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      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 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        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

      • 4 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          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  · 
        • 1 vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            Anonymous shared this idea  · 
          • 5 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              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.

            • 12 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                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.

              • 197 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  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  · 
                • 200 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    Hi Ken,

                    Thanks for logging this suggestion. Yes, this could be quite useful. Others that’re interested in this, please do log your votes so we’ll prioritize this work appropriately.

                    thanks

                    Ashvini Sharma
                    Lead Program Manager
                    Excel

                    Anonymous supported this idea  · 
                  • 15 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      Anonymous shared this idea  · 
                    • 225 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        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.

                      • 89 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          Anonymous shared this idea  · 
                        • 37 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                          • 786 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              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  · 
                            • 675 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                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  · 
                              • 387 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  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  · 
                                • 162 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    Anonymous supported this idea  · 
                                  • 135 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      Anonymous supported this idea  · 

                                    Feedback and Knowledge Base