Feedback by UserVoice

Ed Hansberry

My feedback

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

    We’ll send you updates on this idea

    Great suggestion – thanks again for taking the time to put it on this site and for the thoughtful followup comments. This is pretty related to some other work we’ve got going and already has a fair number of votes, so we’ll work on getting plans in place now and hope to get started on this soon.

    Thanks,
    John [MS XL]

    Ed Hansberry commented  · 

    PowerApps has a BLANK() function as well. It would seem to make sense to add this to Excel for consistency, and perhaps a NULL() in both, though in PowerApps, it treats null and blank as the same.

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

    We’ll send you updates on this idea

    12 comments  ·  Excel for the web » Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  Tamar Tzruya responded

    Thanks for your feedback! We’re reviewing your suggestion. Remember, the more votes a suggestion gets, the more likely it is that we’ll do it.

    Tamar [MSFT]

    Ed Hansberry commented  · 

    This seems to work today.

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

    Ed Hansberry commented  · 

    Roy - I understand if you have two instances of Excel open then they will have separate undo stacks. But the transition from MDI to SDI did not change the fundamental way Excel works. Open 5 workbooks in Office 365, Excel 2016, or Excel 2019, and you only have one copy of Excel.exe running, unless you specifically caused a 2nd instance to launch (Alt-Click Excel icon).

    Ed Hansberry commented  · 

    Roy, MDI and SDI don’t affect the number of instanced of Excel. Still one instance. SDI allows us to move files between monitors though.

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

    Center Across Selection should be the default action as it has the least amount of side effects (destroying ability to sort, causing problems for Tables, adding data to Power Pivot or Power Query, etc.)

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

    Excel has a button to clear all links in Data|Edit Links, but it only seems to work well on links in cells in the spreadsheet, not links in the Name manager, or hidden or more obscure links. That button should wipe out ALL links.

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

    Honestly, I'd be ok if we just got the "Center across columns" button. ;-)

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

    We’ll send you updates on this idea

    0 comments  ·  Excel for the web » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry shared this idea  · 
  10. 24 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Excel for the web » Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
    Ed Hansberry supported this idea  · 
  11. 30 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  · 
  12. 453 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    156 comments  ·  Excel for the web » Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  Tamar Tzruya responded

    Thanks for your feedback! We’re reviewing your suggestion. I would like to clarify: If sharing through SP the URL parameters are hashed. When a user edit an Excel file and copy the URL for sharing over email the user can choose to change the action to edit.
    Remember, the more votes a suggestion gets, the more likely it is that we’ll do it.

    Tamar [MSFT]

    Ed Hansberry supported this idea  · 
  13. 527 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  · 
  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. 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 supported this idea  · 
  16. 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 commented  · 
    Ed Hansberry shared this idea  · 
  17. 256 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

    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.

    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.

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

    We’ll send you updates on this idea

    Hi all,

    I’m happy to announce that your input has had another direct impact on the product. In this case, a decision has been made to have Power Pivot be available in all Windows editions (“SKUs”) of Excel! This means the Business, Home, Standard, etc.. all of these will have Power Pivot. As your comments have indicated, Power Pivot has moved from targeting a specialized audience to generally useful capability for working with data in spreadsheets. As such, it makes sense to make this as broadly available as possible.

    We have started rolling this change out with the April Current Channel updates (Builds 9330 and beyond). I’m also happy to announce that these SKU changes will be reflected on the upcoming 2019 version as well.

    Thank you for pushing for this!

    Ashvini Sharma
    PM Manager
    Excel

    Ed Hansberry commented  · 

    Because @Mimi - this was a licensing decision that involved little to no coding and was just a decision to include it with all Office SKUs for Windows. The one you linked to is a massive code change to go back to the old way. I doubt they will revert that given they are now targeting the new Sets feature in Windows Redstone 5 due this year, and it won't work effectively with all documents in a single container. But they are looking at specific use cases as the post says at the top.

    Ed Hansberry commented  · 

    No exact date for Office 2019, but scheduled for the 2nd half of this year, which could be July 1 or December 31, or somewhere in between. MS hasn't finalized a date yet.

    Ed Hansberry commented  · 

    For those questioning the Insider track, you don't have to do that. LIke all features, MS is apparently rolling this out to Fast Insider first, then will move to Slow Insider when a bit more stable, then to normals when fully tested.

    If you want it right now, then yes, you need to get Fast Insider, but understand you are getting a beta version of ALL of the office apps and there are bugs that may impact you. MS doesn't recommend using Fast Insider on production machines.

    Ed Hansberry commented  · 

    @mark - Office 365 for home is not licensed for commercial use. If your clients are individuals that just pay you to help with their PC needs, that is fine (though seems odd that kind of person would care about Power Pivot), but if your ciients are small businesses, they need to have an Office 365 business license, not home.

    Ed Hansberry supported this idea  · 
  19. 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 shared this idea  · 
  20. 547 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  · 

Feedback and Knowledge Base