489 votes76 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
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.)
52 votes8 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
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.
156 votes17 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
Honestly, I'd be ok if we just got the "Center across columns" button. ;-)
11 votes0 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
6 votes1 comment · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
30 votes1 comment · Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →
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.
506 votes104 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
2 votes0 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
7 votes1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
3 votes1 comment · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
Same idea a the Power BI site for PQ - https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20038996-have-a-visual-indicator-of-steps-that-are-folding
251 votes23 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
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.
Lead Program Manager
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.
@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.
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.
525 votes256 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
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!
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.
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.
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.
@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.
6 votes3 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
531 votes45 comments · Excel for the web » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
286 votes91 comments · Excel for Windows (Desktop Application) » Collaboration and Sharing · Flag idea as inappropriate… · Admin →
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.
Thanks, Scott (Microsoft Excel PM)
@eric Johnson, the reason it requires the cloud is a TON of work is being done by the server, not the Excel clients.
@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.
@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.
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.
@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.
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.
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.
It is here! Must be on the Fast Ring for now though. https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10/co-authoring-comes-to-excel-on-windows-desktops/42ea1b8e-6601-4e53-aeb7-381e50387125?tm=1490719962759
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.
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.
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.
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.
@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.
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.
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.
4 votes0 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
19 votes5 comments · Excel for Windows (Desktop Application) » Collaboration and Sharing · Flag idea as inappropriate… · Admin →
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?