Feedback by UserVoice

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.

How can we improve Excel for Windows (Desktop Application)?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      77 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    • 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
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        72 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

        Hi 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]

      • 12 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

          Update (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.
          ash

          Program 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 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            9 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
          • Don't see your idea?

          Feedback and Knowledge Base