Feedback by UserVoice

Ed Hansberry

My feedback

  1. 489 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  · 
  2. 52 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  · 
  3. 156 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  · 
  4. 11 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. 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  · 
  6. 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  · 
  7. 22 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  · 
  8. 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  · 
  9. 448 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    155 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  · 
  10. 506 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  · 
  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. 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  · 
  13. 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  · 
  14. 251 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  · 
  15. 525 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  · 
  16. 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  · 
  17. 531 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. 286 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Hello All – If you haven’t already heard Coauthoring in Excel is live in production. In July we released co-authoring in Excel for Windows Desktop to all customers in our monthly (cc) current channel. Check out the details and the requirements for collaborating with others in the below support article and let us know how it goes. We’d love your feedback.

    https://support.office.com/en-us/article/Collaborate-on-Excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104

    Thanks, Scott (Microsoft Excel PM)

    Ed Hansberry commented  · 

    @eric Johnson, the reason it requires the cloud is a TON of work is being done by the server, not the Excel clients.

    Ed Hansberry commented  · 

    @anonymous - it depends. If you are in the semi-annual (targeted) channel, you'll get an update in March that should have it.

    If you are in the semi-annual channel (i.e. non-targeted) you won't see it until July.

    See https://docs.microsoft.com/en-us/deployoffice/overview-of-update-channels-for-office-365-proplus for more info on when each channel gets the new goodies.

    Ed Hansberry commented  · 

    @caleb - this has been available to the Monthly Targeted channel (formerly insider slow) for at least 3 months. I am not sure if it is on the deferred channel yet.

    Insider Fast has had it since February.

    Ed Hansberry commented  · 

    We'll Excel Help, since the MS Sharepoint/OneDrive servers are doing A LOT of the work to make collaboration in Excel possible, leaving it on your network won't help. We moved all of our files to OneDrive any teams which uses sharepoint for files. We have collaboration, file versioning, and no worries on backups.

    And we like to think of ourselves as normal people.

    Ed Hansberry commented  · 

    @Anon - stuff stays in fast ring as long as it takes. This was a pretty big/invasive feature to the product so took a lot of testing. I suspect it will stay in slow ring for a while too as they add more users to it and hammer out more stuff. Excel still isn't aggressive enough in pushing the final changes back to the server before closing. I can have a large file, click save then close and my changes are stuck on my machine. I notice when I open the file again and Excel tells me there are unsaved changes to save.

    That has to be fixed before it rolls out to the deferred/stable channels.

    Ed Hansberry commented  · 

    Mike, understand that, but I would say short of Windows, Excel is the most complex product MS makes. Data tables, Power Pivot, Power Query, Consolidation tools, the other Data tools (remove dupes, data validation, etc.) filtering, forecasting tools, outlining tools, watch window, auditing tools, charting tools, conditional formatting, etc.

    Just consider the complex calculation engine Excel has. See http://www.decisionmodels.com/calcsecrets.htm for more on this (including the sublinks), but now imagine making this work with multiple people simultaneously to both minimize the impact of someone keying data or editing formulas without grinding everyone in the file to a halt, or locking up the file. That is just one aspect of it. PPT and Word have nothing like this, and yet this is the very core of Excel.

    Excel is a magnitude more capable than any other Office app, and at least an order of magnitude more complex.

    Additionally, it appears to support local 3rd party addins when collaborating without affecting others in the file at the same time.

    I also wish this had arrived 18 months ago, but I fully understand that if it ONLY got the same due diligence that Word and PowerPoint got, we'd be 2020 or later getting this feature. I suspect it got far far more diligence just to get it where it is today.

    Give the team credit where credit is due. For those that see Excel as Microsoft's version of Google Spreadsheet and just grasp the spreadsheet with some formulas are truly missing so much of what is really underneath the hood.

    Ed Hansberry commented  · 

    Mike, it is a bit easier to do on Google Spreadsheets since that product has perhaps 20% of the functionality of Excel. I've used both Google Docs and Office for many years, so understand the differences.

    Ed Hansberry commented  · 

    That said Brian, it used to be on the roadmap, and no longer is. https://products.office.com/en-us/business/office-365-roadmap?filters=excel

    I'm not sure how much stock I'd put in a promise from May 2016 10 months later.

    Ed Hansberry commented  · 

    I'd be happy if the desktop editing was limited. Meaning some more advanced features like PowerQuery, PowerPivot, array formulas, and some other items were blocked during a co-authoring session. It just needs to be more powerful than the online version. For example, when building a model with someone else, the inability to set up conditional formatting is a show stopper for us as that gives visual indicators that something is wrong or missing in the model when it ultimately goes to end users to use.

    Ed Hansberry commented  · 

    Thanks for the info Mike. I am going to report this through the happy/sad face utility in Excel as a bug. I suggest you do the same since our OneDrive scenarios are different. It must be a glitch in Excel.

    Ed Hansberry commented  · 

    Mike, are you by chance using the NextGen client for Sharepoint sites that was released in preview in Sept? I am seeing the same behavior. I think it is the OneDrive client causing this issue, not Excel itself.

    My current workaround is to open the file, and if I'll be editing, I immediately save it. If it saves, I am ok. If not, I close and reopen until it will save and I don't lose work.

    Ed Hansberry commented  · 

    @dan - a year later, any updates? Is this going to happen? I know that the old "shared file" method for your local network was iffy at best and excluded files with Tables among other things. so wondering if this is even possible. Hoping it is, because we really need it. The Excel Cloud version is too anemic to even open many of our files - due to size or embedded images.

    Ed Hansberry commented  · 

    It bothers me that this isn't listed on the Office 365 Roadmap page. http://fasttrack.microsoft.com/roadmap?filters=excel

    In fact, if you filter by Excel, there are no new features for O365 users in an O365 environment. I know the Excel team is adding features like recent Power Query enhancements, but that isn't specific to O365 business clients like this requested feature is given you need Sharepoint in the middle coordinating the collaboration.

    Ed Hansberry commented  · 

    This is so badly needed. Word and PowerPoint already have this. And please - don't exclude files with tables in them. The "SHARE" feature in Excel used to be pretty good until 2007 when tables were introduced, and using that awesome feature eliminated the ability to share files.

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

    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?

Feedback and Knowledge Base