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. Better Support for Analysis Services Tabular

    It's about time to improve support for SSAS Tabular:
    1. Auto-generate DAX
    2. Avoid splitting a table into a "measure group" and "dimension". See how PBI Desktop handles metadata.
    3. Carry over data types so that users can create reports, such as show me invoices where Due Date is greater than ... Currently, all dimension table fields map to Text.
    4. Many customers have expressed interest to connect Excel tables directly to Tabular, bypassing Pivot Table, so they can use the column dropdowns and other Excel goodness.
    5. Support descriptions as tooltips when the user hovers on a field in…

    51 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

      0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    • Choose wheter you want to also copy workbook model or not when copying worksheet

      When you copy a worksheet that has tables or pivot tables linked to a Power Query connection or Data Model into a new workbook, Excel copy all the dependencies of the tables/pivot tables.
      If you have a large data model, each worksheet copy can take minutes to process.
      It would be great if we had an option to choose wheter we want to bring the connection and data models with the new copied worksheet, as the attached file.
      Notice also to not forget to add VBA parameters in the Worksheet.Copy methode to access this feature programatically.

      13 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

        0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
      • Power Query Advanced Editor and Formula Bar Intellisense

        Add intellisense to the advanced editor and the formula bar for the Power Query M-Code.

        13 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

          5 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
        • Expand/Collapse function in pivot charts for the 'Legend' (Pivot Column Group)

          Expand/Collapse function in pivot charts for the 'Legend' (Pivot Column Group)

          1 vote
          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

            0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
          • Pivot charts have too much white space as standard

            Currently Pivot Charts consistently display too much white space (above the max and/or below the min value on the y-axis).

            I don't know what the coded logic is for automatically calculating the bounds of the axes, but it needs to be fixed.

            1 vote
            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

              0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
            • Index Columns

              Allow for a quick toggle to quickly show the index number next to the column letter. When selected, the columns would read A(1), B(2), C(3)...etc This would allow us to quickly reference what the index should be for the pivot table. Then we can turn the toggle off and it goes back to normal A, B, C. Thanks!

              1 vote
              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

                0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
              • Link Pivot Table Timeline slicers with data slicers

                I use pivot tables with "normal" slicers and with timeline slicers.
                If you add two normal data slicers they interact with each other in that if you make a selection in one slicer it filters the possible attributes in the second slicer.
                If you use a timeline slicer and select a given period, this does not filter the normal slicers to show only valid attributes for that period and vice versa.
                I want to be able to select a time period and for the slicers to only show attributes which have a value in that period. At the moment I…

                1 vote
                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

                  0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                • when we create a pivot and draw down but when we have to convert all value from count to sum So, there were tick mark option to be given fro

                  when we create a pivot and draw down but when we have to convert all value from count to sum So, there were tick mark option to be given fro

                  1 vote
                  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

                    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                  • Hide the "many" side of Power Pivot relationships by default

                    When we link a dimension to our fact tables, we rarely want to use this field on our Pivot Tables. We should be using the field from the One (Dimension) side as this allows proper cross filtering. I see many users get confused by why their filtering is not working after linking tables, and it is invariably due to the fact that they've put a value into the Values area, then used another field from that same table in a row/column/filter/slicer or timeline.

                    Hiding the many side of a relationship would go a long way to stopping users from getting…

                    7 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 →
                    • Give us a pivot filter which accepts a list of values

                      To Filter a pivot table by a specific value you have to choose the value manually in the filter area. Let´s say you have a list of values that you would like to choose to filter the pivot. The process of manually pick those values in the list of the filter criteria of the pivot is very time consuming.

                      If there was a possibility to give the filter a list of values (as it is possible in SAP ERP) that process whould be much faster.

                      1 vote
                      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

                        0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                      • Support the grouped gridlines with PivotTableStyle to make it similar to the old style PivotTables

                        I need the old style Pivottable formatting as explained in the below url but when I apply a custom pivot table style to it the grouped gridlines disappear so is it possible to have the best of both worlds.

                        http://blog.contextures.com/archives/2010/05/14/pivot-table-formatting-old-style/

                        This is what I did

                        Create a pivot table with multiple row headings
                        Set the Pivot table layout to Tabular
                        If you set the Pivot Table Style to NONE, the gridlines show up very nicely. but there isn’t any color.
                        As soon as you pick another style (with color), the gridlines disappear.
                        I tried modifying the colorful style to include…

                        1 vote
                        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

                          0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                        • Enable pivot table range selection by right clicking the mouse button

                          Stop making users go to the ribbon to select ranges. Allow right click on pivot table to select new ranges.

                          1 vote
                          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

                            0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                          • PowerQuerycommand Move Column to First Column

                            When you move a column to be the first column, the script created list ALL the current columns. As some data might be dinamical, columns could vary on a different query...
                            I thought it'll be usefull to delete all the "variable" columns and just set the first fixed columns... (thinking that the left ones would come right to those selected) but it doesn't work as planned. Could you improve this command to be able to do so... so it'll work no matter which columns are available in the query.

                            1 vote
                            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

                              0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                            • make Pivot Table Filters/Columns/Rows/Values boxes stretchable in all directions.

                              I'd like to see the Pivot Table Filters/Columns/Rows/Values boxes stretchable in all directions. They are too small to manage more than a couple fields.

                              2 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

                                0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                              • Pivot table-change multiple value fields at once

                                Allow user to change multiple value field settings (example multiple columns to sum) at one time. Would be even better if it could be done like right clicking to format cells.

                                2 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

                                  0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                                • Add Grand Totals on Stacked Column/Bar Pivot Charts

                                  MOST of the time I do a Pivot Chart using stacked columns, I want to be able to see a Total for the entire stack. It should be a very simple, intuitive way to do it, but seems like a huge workaround for something that should be a given. Either as Data Labels or as an option to add the Grand Totals as a series to the PC.

                                  2 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

                                    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Ability to lock moving and resizing of TimeLines

                                    Currently it is not possible to create a Timeline that can be interacted with by the user, but not moved or resized. For the Slicer, the option "Disable resizing and moving" is available. For the TImeline however, this option is permanently greyed out rendering the method impossible. I've searched for countless of hours and the only responses from Microsoft support have been "That is not possible, sry". It just doesn't make sense that you can do it with Slicers but not with Timelines. Please fix this.

                                    1 vote
                                    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

                                      0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Filter year, quarter, month, week, day in pivot without the need of helper column

                                      Right now, we need helper column to file month, week and day. Place make avaliable in grouping menu.

                                      1 vote
                                      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

                                        0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Grouping Feature

                                        When grouping by a set number of days, we need to be able to sort oldest to newest without it basing the sort on the first digit. If I group by week, I want the oldest from when the grouping begins

                                        1 vote
                                        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

                                          0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                                        • make "queries & connections" pinnable so that it can remain visible when you save and open the file

                                          A. change or add item "Get and Transform" as that is what Microsoft is calling this functionality.
                                          B. see my item title.
                                          C. Why cant a company that invented enterprise computing and is worth almost a trillion dollars - and I am a huge missionary btw - but seriously, why cant it manage to open user voice in edge? or outlook customer manager for that matter? its almost like a bad nerd joke

                                          1 vote
                                          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

                                            0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 11 12
                                          • Don't see your idea?

                                          Feedback and Knowledge Base