Excel for Windows (Desktop Application)
Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.
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.
-
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…
560 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 votesHi all,
This ability to turn off time grouping from the UI was recently added to the O365 version of Excel. File→Options→Advanced→Data→“Disable automatic grouping of Data/Time columns in PivotTables”.
We’re considering adding this back to the perpetual release of Office 16. Until that’s available, you can also turn it off manually using the registry, outlined in this article: https://support.office.com/en-us/article/Turn-off-time-grouping-in-PivotTables-in-Excel-2016-for-Windows-6be5afed-348c-4db2-9f87-5ac262d67b3f.
Regards
Ashvini Sharma [MS] -
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?