Feedback by UserVoice

Ed Hansberry

My feedback

  1. 328 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    I half wonder if there is no impetus at MS to do this because if you do this in Power BI, the query is automatically hidden from the end user, and they get a $10 Power BI license.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @regan - that would work but has serious limitations as it becomes difficult to quicky modify/tweak the query, and prevents it from being used in a MERGE or APPEND without breaking query folding. No subsequent tasks in the query would fold either.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Ryan, that does work, but it also causes DAX to fail. So if your query is loaded to a table, that is fine,but if it feeds PowerPivot, it causes PowerPivot to stop working, or anything that relies on the Data Model, like the CUBE functions.

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

    We’ll send you updates on this idea

    Ed Hansberry shared this idea  · 
  3. 613 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry supported this idea  · 
  4. 6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry supported this idea  · 
  5. 19 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
    Ed Hansberry commented  · 

    Not sure how this would work. Unless you are talking about queries that take hundreds of hours (in which case, Excel is the wrong tool anyway), like the distributed computing projects that are online, anything you did locally on your LAN would be slowed down by the LAN itself. You'd need a server to parse out the queries into chunks, but then why not let the server do the work for you?

  6. 461 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]

    Ed Hansberry supported this idea  · 
  7. 2 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
    Ed Hansberry commented  · 

    This was added to Excel 2016 months ago if you have an Office 365 subscription. If not, it will likely be in Excel 2018 or 2019, whatever they call it. My guess is when Excel 2018 hits the streets, everyone with Office 365 will have already had those features since O365 updates every month.

    https://support.office.com/en-us/article/set-pivottable-default-layout-options-efd8569c-f07a-43c1-9db2-4f2912a0f94e

  8. 14 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
    Ed Hansberry commented  · 

    This would be very helpful, and aid in building models in Excel before putting in Power BI. The CROSSFILTER function allows it, but is unnecessary in Power BI and adds work.

    Ed Hansberry supported this idea  · 
  9. 145 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
    Ed Hansberry commented  · 

    This already works on files with Sharepoint. Hoping a OneDrive solution is on the way.

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

    I should be able to subscribe to any file in OneDrive, OneDrive for Business, or any Sharepoint site in Office 365 to get an email the next morning when the file was updated.

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

    We’ll send you updates on this idea

    Ed Hansberry shared this idea  · 
  11. 15 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
    Ed Hansberry commented  · 

    Also, can we get a Group name the query is in? It would help in visualizing since I usually try to group queries by Source, Intermediate, and Final.

    And maybe color code the "loaded/not loaded" boxes. For example:
    Loaded to worksheet - green
    Loaded to data model - blue
    Loaded to both - Yellow
    Not loaded - white

    Ed Hansberry shared this idea  · 
  12. 36 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
    Ed Hansberry commented  · 

    @lynn - when you enable the legacy connection in Options, go to the Data ribbon, Get Data. There will now be a LEGACY WIZARDS menu with the options you checked.

    On PowerQuery - it is much MUCH easier than learning and using the old legacy connections. You do NOT have to be a database admin. When you have 10min, try the PQ 101 tutorial. https://support.office.com/en-us/article/Power-Query-101-008b3f46-5b14-4f8b-9a07-d3da689091b5

    You'll wonder how you ever worked without it.But until you do, the legacy wizards are there for you.

  13. 601 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
    Ed Hansberry commented  · 

    @oz - how would being in another app, like Chrome or Outlook, be affected if Excel, on another screen or window, still visually show the selected cells? I often highlight relevant cells and would like to compose an email based on that info, but cannot because the highlight vanishes until I return to Excel. it forces me to color those cells, then uncolor them when done.

    But I am genuinely curious as to how the highlight continuing on even when the app is not in focus is a disruption to your work flow.

    This seems to be an MS only thing. Other apps retain selection visually when you switch away.

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Thanks for the feedback! We’re seeing a number of different posts about lookup functions – we’ll be taking a close look at this area and thinking it through. We’ll prioritize the asks according to votes along with other requests on the site. So I encourage people to keep voting if it’s something they really want to see the priority raised on.

    Best,
    John [MS XL]

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    FWIW, you can do the multilookup today. http://www.exceltactics.com/vlookup-multiple-criteria-using-index-match/4/

    It is just a convoluted set of Index, Match, and entering as an array formula. A pain to build, but works beautifully and no VBA required.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Include the ability for a negative offset to the lookup column doesn't have to be the first column.

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

    We’ll send you updates on this idea

    Ed Hansberry shared this idea  · 
  19. 199 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry supported this idea  · 
  20. 533 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
    Ed Hansberry commented  · 

    You also need to be able to save a file (in case of crash) to ensure that you aren't working in Excel for hours on M-Code and lose it all. Having to close the PQ window, then save all changes, then save the file, then reopen the query editor, is absurd.

    Ed Hansberry supported this idea  · 

Feedback and Knowledge Base