Excel for Windows (Desktop Application)
Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more
To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.
-
Power Query Advanced Editor and Formula Bar Intellisense
Add intellisense to the advanced editor and the formula bar for the Power Query M-Code.
48 votesA little bit late updating the status on this suggestion, but we’re happy to say that Power Query now has Intellisense when using the Advanced Editor and the query formula bar. If you don’t see it already, just go to File > Options and Settings > Query Options > Power Query Editor, and enable M Intellisense.
-
Allow users to set/choose defaults (via settings) for PivotTables - Layout (compact, tabular, classic, etc.), PT Options, etc.
Excel 2007 introduced the new Compact Form and made it be the default for all future pivot tables. With this layout, multiple row fields are compressed into column 1 of the pivot table. This makes the data very difficult to later re-use.
My request is to add a setting in Excel Options where each person can choose their default pivot table layout. All future pivot tables will use Tabular, Outline, Compact, or Flat. (Flat is a new layout introduced by Power Pivot... it is Tabular with no Subtotals).
Additionally, the same settings area shouls allow the user to save other…
559 votesHi there,
On behalf of the Excel team & with great pleasure, I announce this feature has now been released to Office 365 subscription customers. More information is available at https://blogs.office.com/2017/05/15/pivottables-just-got-personal/.
Thank you to Mr. Excel for suggesting this idea and to the community for rallying on it!
Best,
Ash[MS XL]
-
Disable time grouping
The new automatic time grouping in PivotTables should be an option within Excel. Users should not need to make a registry edit to disable this feature, and the time grouping should not be on by default.
10 votes -
Make Power Pivot available in all versions of Excel
Previous title: "Make the Power BI Family - PowerPIvot + PowerQuery + PowerView and PowerMap available in all versions of Excel".
532 votesHi folks,
We’re happy to report that Power Pivot is now in all current Windows editions of Excel, including Office 2019 (perpetual) and Office 365 (subscription).
In older versions of Excel (Excel 2013, Excel 2016) only certain Windows editions (Pro Plus and higher) include Power Pivot.Thanks for helping us to make this a reality!
Vai
Excel Program Manager -
OData and PowerPivot removes separator on actual billable hours
Please solve this Click2Run Excel bug. I'm looking for the solution for since the start of the year now, this is the forum post: https://social.technet.microsoft.com/Forums/projectserver/en-US/061de981-fa09-46c4-9ff5-c57c0601625e/odata-and-powerpivot-removes-separator-on-actual-billable-hours?forum=projectonline#a730e4e8-86dd-4377-95cd-6b441bb26ddc
12 votesUpdate (July 25)
Hi again Erik,
This issues should be fixed in our August 2nd update.
If it isn’t, pls reach out to me directly at myfirstname dot mylastname at microsoft dot com.
Thanks again for raising it.
ashProgram Manager
Excel—
Hi Erik,
Boy, you’ve been having quite a saga here. Even though this site is for new requests, appreciate finding out about this. I’m reaching out to Brian to understand what’s happening so far.
thanks
ash [Microsoft Excel] -
Kindly make power pivot option as a standard in excel 2016
The use of pivot has increased over the period of time. Currently power pivot is provided as add-in and is not part of standard excel. Request you to make power pivot as a standard option in next release of excel i.e. Excel 2016
12 votesHi Srikanth,
As Yigal mentioned, PowePivot is now part of many Excel 2016 versions, as noted here: https://blogs.office.com/2015/09/18/new-ways-to-get-the-excel-business-analytics-features-you-need/
Hope you’re enjoying the new version of Excel!
dan [MS]
- Don't see your idea?