Feedback by UserVoice

Ed Hansberry

My feedback

  1. 9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry supported this idea  · 
  2. 7 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry supported this idea  · 
  3. 17 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    See this discussion in the Excel Tech Community for a specific example of what happens. https://techcommunity.microsoft.com/t5/excel-blog/announcing-xlookup/bc-p/830248/highlight/true#M708

    Attached workbook will show how this works.

    Ed Hansberry supported this idea  · 
  4. 772 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    We are excited to share an update on the feature availability. This is available on Excel Insiders min build: 16.0.13525.10000, and on Mac Insiders min build:16.44.1125.0. We will post updates here as this rolls out to Current Channel. (A description of Office channels can be found here: https://docs.microsoft.com/en-us/deployoffice/overview-update-channels )

    If you are excited by this change or have comments for us, please share at File→Feedback.

    Thanks, Urmi

    Ed Hansberry supported this idea  · 
  5. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    I wouldn't hold my breath on this. MS seems to be moving to Power Platform for this kind of thing, which does support Excel as a backend, and a front-end soon. Between Power Apps and Power BI, plus whatever data source you want, like CDS or on-prem sources like SQL server or even Access databases, all of the functionality you discuss is there, and much MUCH more.

    It seems they are removing features from Access, not adding. They will not add Power Query to it (that idea with well over 1K votes was rejected), Data Access Pages was killed, Pivot queries were killed, and the Access to SQL upsizing wizard was killed.

    They haven't officially said of course, but Access seems to only get nominal features to keep it on par with other Office 365 apps, but there are no real breakthrough features.

  6. 349 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks everyone for showing a lot of passion about Dataflows data connector in Excel! We’re evaluating our future investments and your votes help us to prioritize. Please keep voting if you like this idea.

    Guy Hunkin
    Principal Program Manager
    Excel Team

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    FWIW, in the Office 365 Insiders build of Excel, Power Query has a "Power Platform" menu as a data source that is grayed out, and one of the members on the team said functionality was coming. I would hope that would include Power BI data sets, Data Flows, and CDS, just like it does on Power BI Desktop. I keep checking every week. It first showed up a month or so ago, or at least that was when I first noticed it. So it is coming....

    Ed Hansberry supported this idea  · 
  7. 517 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for your support of this suggestion and all the great ideas in the comments. We have at least one improvement planned (resizing the dialogs – see link in the description), and we’re looking at some additional improvements.

    If you have specific ideas that aren’t already listed, please add them in a comment.

    Steve [Microsoft Excel]

    Ed Hansberry supported this idea  · 
  8. 19 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry supported this idea  · 
  9. 1,532 votes

    We're glad you're here

    Please sign in to leave feedback

    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

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

    Personally I think ms would like to see Access die. PowerQuery has replaced virtually all of our “read” queries and SharePoint lists, excel tables and even SQL Express are easy to use. 2 years ago ms started giving access to all office pro licenses in 365. They seem to no longer consider it a premium product.

  10. 119 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry shared this idea  · 
  11. 14 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry supported this idea  · 
  12. 2,285 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Hi all,

    We have been working on this, and wanted to get your feedback on how you see this feature fitting into your workflow. We have a quick one question survey for you to give us your thoughts on the look and keyboard shortcuts we have at this time. Please see here for more: aka.ms/datePickerSurvey

    Thanks!
    Blake, Excel Product Team

    Ed Hansberry supported this idea  · 
  13. 1,532 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks very much for your votes. And to those who took the time to fill in the survey, thank you! This is a brief update to let y’all know that we’ve started work on this feature request along with the one on changing numbers to scientific notation.

    - Urmi [Msft]

    Ed Hansberry supported this idea  · 
  14. 3,572 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    I’m happy to let you know that we are in the planning stages to make Excel for Windows scroll without jumping to the edge of the cell so you’ll be able to scroll smoothly. We don’t yet have a target date, but wanted to tell you about our plans.

    We appreciate all the votes and comments supporting this suggestion.

    Thanks – Steve K [Excel]

    Ed Hansberry supported this idea  · 
  15. 6,751 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Wow.

    Thank you to all those participated in our survey. What an amazing number of responses, many of them with very deep content. We’re processing the over ten thousand responses(!), and already appreciate the time so many of you took to answer with passion and experience.

    Please know this survey is used to help influence various topics – both on Python as well as other related topics that the comments started to bleed into. Given the passion, I want to be clear this remains an area of exploration for us, without any specific timeline.

    We’ll provide updates as we progress on this feature request.

    Thanks!

    Ashvini Sharma
    Lead Program Manager
    Excel

    Ed Hansberry supported this idea  · 
  16. 65 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @sergie - Mac, iOS, and iPadOS all have Dynamic Array functions for Insiders. Not sure about Android, but it will if it doesn't now.

  17. 192 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    We’ve started rolling out the improvement to make the Conditional Formatting Rules Manager and rules dialogs resizable in Excel for Windows.

    If you have the latest update, you may already have the improvement. Make sure you update to version 16.0.136 or greater, and you should see the changes soon, if not already.

    Thanks for all the votes and comments for this suggestion.

    Steve [Microsoft Excel]

    Ed Hansberry supported this idea  · 
  18. 145 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ed Hansberry supported this idea  · 
  19. 170 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    The biggest shortcoming to the new Dynamic Array functions is the inability to use them in a table.

    Ed Hansberry supported this idea  · 
  20. 4,133 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    903 comments  ·  Excel for Mac » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for supporting this suggestion with your votes. It’s unlikely that we’ll be able to bring PowerPivot to Excel for Mac, because it relies on features of the operating system that don’t exist on Mac OS. We’ll keep tracking votes, since we know that the scenarios made possible by PowerPivot are important, even if the solution will need to be something else.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @anonymous - Keynote may be cool, but it is a PowerPoint competitor, not Excel. And I've used Numbers, and it is sorely lacking in what Excel can do, especially the new dynamic array functions. I tried Numbers for 3 months and couldn't get enough functionality out of it for my use cases. And it doesn't have a Power Pivot equivalent either, so not sure how that is better.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Which office suite would you recommend @fred that we switch to that gives PowerPivot capabilities for macOS

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    That is for Power Query @massimo. I'm hoping Power Pivot will follow on later. Hoping...

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @shahin - because Google Sheets or Numbers has a Power Pivot equivalent on the Mac? It has been a few years since I worked day to day in Google Sheets, but when I did, it's pivot tables didn't even compare to Office 2003.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @anonymous - that is correct. The Mac doesn't have the necessary engine to refresh data in the Data Model that Power Pivot uses. Until MS adds Power Pivot to the Mac (if they do) you only have two options - install Excel for Windows on the mac via Paralells or similar software, or use Power BI. Power BI has the same engine as Power Query and Power Pivot, but returns the result to a web page, and any client with a web browser and permissions to the page can render it.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    @nathan - the price is for office 365 in general. You install whatever version you want for your computer OS.

    Since the price for the Windows version didn't increase with the addition of Power Query or Power Pivot, I'd surmise they consider that free enhancement.

    All that said, I want this on my Mac as well, but there is no pricing disparity.

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    If you read this thread on Answers, it looks like MS is making some internal progress on this feature... at least the Mac recognizes there is a data model. https://answers.microsoft.com/en-us/msoffice/forum/msoffice_officeinsider-mso_mac-msoinsider_excel/workbook-using-a-new-feature-in-excel-for-windows/8f18af1c-d9df-40e1-8646-49a0d22ffb85

    An error occurred while saving the comment
    Ed Hansberry commented  · 

    Google has Power Pivot?

    Ed Hansberry supported this idea  · 
← Previous 1 3 4

Feedback and Knowledge Base