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. Bug: wrong data from OLAP source

    Incorrect values of dimension in pivot table sourced on OLAP cube (Microsoft SSAS 11.0.5569.0). The latest version without that bug is 16.0.6001.1068. Obviously we don’t know exact source of this bug, but most of the issues we discovered were on complex pivot tables with many attributes, partially displayed dimension’s hierarchy and without subtotals. Example of this bug occurring is in attached file ExcelBug. There are 2 exactly the same pivot tables (the table on the right hand side is basically copy of the table on the left hand side). After removing “Grand Total” on the table on the right hand…

    16 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 Pivot Option in Excel app of Home & Business 2016 version

      I purchased the office home & business 2016 for PC version. The idea was to learn features like power pivot/Power queryl. but to my dismay this version of the excel does not have this feature in built. Isn't this supposed to be a standard feature

      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

        2 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
      • Allow dates to display un-grouped by default

        Make a setting to allow dates to display un-grouped by default. Currently when you add dates to the pivot table fields it creates the quarter, month, year deal and you have to right click and ungroup. I see the usefulness of both ways but ungrouped is used far more by some users.

        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 →
        • Refresh All for Pivots and data connections should have a way to set up the order of update

          Refresh All for Pivots and data connections should have a way to set up the order - at least how it progresses from tab to tab, or from top to down on a sheet. Right now, it seems like a black hole on which pivot/tab is getting updated first and which one is last if I have a workbook with 10 tabs and close to 30 pivots and few data connections. I do not see a way to either set an order or find the order in which Refresh All is working.

          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 →
          • Remember collapsing state of folders of queries in Power Query

            In the current version all the folders are open when you launch PQ. It would be useful if PQ would remember their stat at the moment of last closing PQ window.

            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 →
            • Power Pivot to show real target values, incl. the %limits

              In a PivotTable, KPI measures have three components: value, status and target. But the target, in case of calculated targets, shows the same value as the measure that is used as basis for the target while in most cases there are limits set. E.g. green color when actual value >= 110% of measure [Same Period Last Year].

              So the PivotTable should show the 110% * [Same Period Last Year] measure value, incl. the limit of 110% otherwise we can add just as well the measure [Same Period Last Year] as there is no difference between the KPI Target and the…

              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 →
              • power pivot - link to VBA (2)

                There does not seem to be in power pivot any way to access a sheet directly. There is the Excel.CurrentWorkbook function, but that does not give sheet details and these are needed if, for example, there are a number of identically named tables but on different sheets.

                Furthermore links to Excel sheets are broken if the user changes the sheet name and there is no way in Excel of trapping this (no RenamedSheet event is exposed).

                Combined together this makes accessing Excel data in Power Pivot problematical.

                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 →
                • power pivot - link to VBA

                  Power pivot is great but its integration with Excel is poor. it would be good if we could link the output from Power Pivot directly to be read into a VBA array rather than having to output it to a table first then read the table. Not least because there doesn't appear to be an easy way to ensure that query has finished running before the VBA code continues.

                  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 →
                  • Transform Files - move to a top level tab with Queries and Connections

                    The transform File groups created by binary transformation are for the most part never touched by the user and yet have been implemented in the graphic query hierarchy to create nodes at the top - couldn't be more in the way and hamper productivity more - make them essentially invisible by putting them in their own top tab next to Queries and COnnecitons

                    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 →
                    • New tab on Pivot Table

                      What I would like to see in Excel is this: When we create a PivotTable, and double-click an item it opens a new tab, it could be a window so we can see the details, and when we want, we just close the window , the way it is today is very annoying, have to be deleting the worksheets that are created

                      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 quick measures like in Power BI available in Excel as well

                        In Power BI we can easily create quick measures: https://powerbi.microsoft.com/en-us/blog/quick-measures-preview/
                        This makes it so much easier for newbies or occasional users to adopt the new technologies, so please add in Excel as well.

                        37 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 →

                          Hi Imke & others,

                          Thanks for logging this suggestion and voting on it. Yes indeed this would be very useful to make it easier and quicker.

                          For those that’d like to get this done, please be sure to register your vote to help us prioritize against out backlog.

                          thanks

                          Ashvini Sharma
                          Lead Program Manager
                          Excel

                        • Allow Collapse of Values field in Pivot Tables

                          With two or more value fields on a pivot table, the auto-generated "Values" field gets added to the rows or columns of the pivot table, and acts somewhat like other row/column fields. However, it would be great if the user could expand/collapse/filter the Values field. Collapse would help to provide asymmetric reporting and would also allow the user to effectively put a Grand Total on the left side of the pivot table by collapsing the Values field for that particular item.

                          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 ability to collapse field areas in PivotTable Field and Area Side by Side view

                            With the ability/normal experience of creating many DAX measures in Power Pivot, the Values area of the PivotTable design is now too small to use effectively. Since the Values area only shows about 4 rows it's really difficult to organize fields correctly when try to drag fields around if you've got 10 or more fields in your Values area. (not at all uncommon for Power Pivot users, although certainly not restricted to them.)

                            With the introduction of slicers, however, we also tend to use the Report Filter area less, and don't usually add as many fields to the row/column areas.

                            367 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

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

                              Hi Ken,

                              Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

                              thanks
                              ash [MS XL]

                            • 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…

                              55 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 the ability to run percentiles in pivot tables

                                I see a request already to add the ability to run medians in pivot tables--would love to be able to do this, and also to run other percentiles.

                                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 Roles to Power Pivot

                                  Currently, the "roles" functionality, which enables row-level security, is available in tabular data models and Power BI desktop. I would like to use this feature in Power Pivot. To elaborate, I'd like to load a full data set, and have Power Pivot filter the data model shown to the current user, based on their security profile. I can set this fairly quickly in Power BI Desktop, not sure why it isn't an option for Power Pivot.

                                  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 →
                                  • Expand/Collapse function in pivot charts for the 'Legend' (Pivot Column Group)

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

                                    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

                                      1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Make "Disable Automatic Grouping of Date/Time columns" configurable within the pivot table ribbon

                                      I need to disable/enable frequently for reporting and it is frustrating to dig through advanced options. After I toggle the option I have to copy my data to a new workbook for the setting to take effect. I should be able to turn this feature on and off within the pivot table ribbon, without opening a new workbook.

                                      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!

                                        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

                                          1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Pivot table format division wise colouring and Merge centre

                                          On pivot table, a new format can be include to show a report in column and row.
                                          For eg: when a pivot report prepared for country/state wise, eg. India should be in Merge-center & its states should be in below row;

                                          India
                                          TN KER KAR AP

                                          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 13 14
                                          • Don't see your idea?

                                          Feedback and Knowledge Base