Feedback by UserVoice

Ed Hansberry

My feedback

  1. 419 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  · 
  2. 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 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

  3. 303 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. 14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Ed Hansberry commented  · 

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

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

  6. 116 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    22 comments  ·  Excel for the web » Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry commented  · 

    @tim - they are not locking the offline file. Excel for PC and Mac both support collaborative editing with the online version now, as do the iOS and Android versions.

    This wasn't true 60 days ago, but MS rolled that out for Excel in Office 365 just recently.

    Ed Hansberry commented  · 

    @tom - I know of no way to force Excel online use, but you could be creative with a formula. The Function INFO() doesn't work in Excel online, so if you put that in a file, like =info("Directory") Excel desktop will return the user's directory, but Excel Online will report #Value!. Wrap that in an ISERROR() function, you could have a warning at the top of the file.

    =IF(ISERROR(INFO("Directory")),"","Please close this file in Desktop excel and use Excel Online. Thanks.")

    That will be blank in Excel Online, but show the warning in Excel desktop. Add some red conditional formatting for even more attention.

    That said, Excel in the Fast Ring currently supports real time collaboration, so hopefully this will be temporary for you. But I don't know when Excel in the Current or Deferred channels will get this new feature that is in beta right now.

    Ed Hansberry commented  · 

    Hubert - just create a single cell watch window. Excel Online will mandate the file be opened in Excel. It won't even try.

    Ed Hansberry supported this idea  · 
  7. 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  · 
  8. 13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    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.

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

    We’ll send you updates on this idea

    Great suggestion E Bow. Thanks for taking the time to tell us about changes you’d like to see – we’re listening. We’ll take a look at this one. As always, folks should keep voting for the things they like the most – we’ll generally be prioritizing things according to the number of votes they get.

    Cheers,
    John [MS XL]

    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  · 
  11. 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  · 
  12. 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  · 
  13. 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  · 
  14. 342 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]

    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.

    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  · 
  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 shared this idea  · 
  16. 730 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 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]

    Ed Hansberry supported this idea  · 
  17. 133 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  · 
  18. 27 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry commented  · 

    Yes! A form of tab-grouping.

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

    We’ll send you updates on this idea

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

    We’ll send you updates on this idea

    Ed Hansberry commented  · 

    Actually just need another argument for the =CELL() function. =CELL("Sheetname",A1)

    Ed Hansberry supported this idea  · 

Feedback and Knowledge Base