Feedback by UserVoice

Anonymous

My feedback

  1. 105 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Anonymous commented  · 

    Just thinking about the possibilities gets me fired up. Please, oh, please!!!

    Anonymous supported this idea  · 
  2. 246 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous supported this idea  · 
  3. 17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Anonymous commented  · 

    I'm going to vote NO on this. I'm glad my co-workers can't lock up critical tools with passwords only they know and then leave the company. It's like a deadbolt lock. It slows most people down but if we have to ***** it, we can. Most of the time what the dev thought was "sensitive" was some slapdash code that did sommersaults & cartwheels around the workbook but no one wants to "steal" it for themselves. We're just trying to get work done.

  4. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Anonymous commented  · 

    Same for me.
    Sort should just work regardless of any cells protected in the table.This needs fixing.

    I choose Protect Sheet and check boxes to allow Sort & Filter. But users can't sort.
    This was very confusing since the Protect Sheet dialog implies that they can.
    I'd have to remove the protection on the ENTIRE TABLE which defeats the purpose of protection.

    Anonymous supported this idea  · 
  5. 1,449 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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  · 
  6. 224 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous supported this idea  · 
  7. 17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    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  · 
  8. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous supported this idea  · 
    An error occurred while saving the comment
    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.

    An error occurred while saving the comment
    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

  9. 7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    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  · 
  10. 5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous supported this idea  · 
    An error occurred while saving the comment
    Anonymous commented  · 

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

  11. 16 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    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.

  12. 290 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    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  · 
  13. 595 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for taking your time to suggest and vote for allowing interaction with Excel while in Power Query Editor window. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.

    Guy Hunkin
    Excel Team

    Anonymous supported this idea  · 
  14. 24 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous shared this idea  · 
  15. 345 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for taking your time to suggest and vote for being able to protect Power Query with a password. This is a good idea, but we don’t think we’ll be able to support this in the near future. We’ll continue tracking votes for it.

    Guy Hunkin
    Excel Team

    An error occurred while saving the comment
    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.

  16. 220 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous shared this idea  · 
  17. 46 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

  18. 1,087 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks to everyone for the votes and discussion about having undo independently in each workbook. Even though this request has been here for a long time, we are listening and we realize that it can be frustrating if you press Undo while you’re in one workbook and it undoes something in another workbook. We’ve been considering the technical challenges to make Undo work “per workbook”, and want to share some details about it with you.

    The undo process relies on the state of all open workbooks being exactly the same after an “undo” as they were before the undone action was taken. One example of how undo “per workbook” is problematic is with linked workbooks. Let’s say you have WorkbookA, with a formula that refers to WorkbookB, such as =SUMIFS. This formula will give the sum of values in WorkbookB in range A1:A10 that have “Yes” in the…

    Anonymous supported this idea  · 
  19. 477 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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  · 
  20. 211 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous supported this idea  · 
← Previous 1

Feedback and Knowledge Base