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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. DAX measure filter is not retained in excel pivot table show details sheet

    DAX measure filter is not retained in excel pivot table show details sheet. Appreciate any help.

    "I filtered for Application Status = "Active" in the measure and it showed the count correctly in pivot table (143),
    whereas when I double clicked pivot to see show details sheet, I saw not only "Active" but all statuses and the count is 211"

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  2. It would like to be able to e-mail the results of a Pivot table to the relevant person/org without showing other organization's data.

    Working at a SELPA, I have lots of private information that each school needs. I would like to automate the monthly mailing of their information - and only their information - so I don't have to separate it and make a new worksheet for each person, and then e-mail it.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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.

    7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  4. Pivot Table Overlapping Error

    Please develop the dialogue / call out from simply stating 'A pivot table cannot overlap another pivot table' so that you are actually provided with a sheet and / or cell reference where an overlap is trying to occur.

    If you have a large workbook / multiple sheets with many pivot tables it can be difficult to find the source of an overlap.

    17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  5. make pivot table to work

    Pivot tables should work as promised. The filed list is missing and does not show even if it is selected in the show tab.
    What a waste of time

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  8. Add search field in PivotTable Field List

    Currently when you have dozens of fields for a source table, it takes a long time to scroll through and find the field you want to include in your pivot table.

    - Add search field in PivotTable Field List to allow user to search for field when table has high volume of fields

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  9. power query load to table auto name tabs with query name

    When you create a query and load to a table, automatically name the tab with the name of the query. This could be a configurable option to check box in either query settings or in the options section.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  10. Expand/Collapse function in pivot charts for the 'Legend' (Pivot Column Group)

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

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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.

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  13. Add an option in "pivot table" to sort data same as the "original order"

    when creating pivot table it will sort data
    A-Z, Z-A, or MANUALLY
    it will be great if you add another option to allow the sorting the same order as they were. "original order"

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  14. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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.

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  16. sort out protection for power pivot tables

    with a power pivot table one obviously wants users to be able to do certain fairly fundamental things like sorting the data if the filter button is available or refreshing the data (which will insert and delete rows and columns, but not play around with its format or the values.

    But the protection options available on the worksheet are too limited.
    There needs to be an option to protect the sheet but allow tables to be refreshed and sorted.

    This was a bit of a pain when this was not available with oldfashioned pivot tables, but with the use of…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  17. power pivot output to combo boxes and listboxes

    Could we have the output from a single-column power pivot directly available to a combo box or list box (either a form control or a vba control)? It would save having to go via a table in a hidden worksheet (which has all sorts of problems keeping a vba listbox in sync with it) and make the combobox/listbox so much more flexible.

    A more complex step along the same lines would be to allow the output directly into a dropdown list created in Data Validation.

    You would need an auto-refresh option on these, as otherwise these could get out of…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  18. Slider slicer

    Can we have the option of having a Slider slicer, sometime the buttons take too much room, or make little sense if you have numbers as your slicer options.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  20. Bug: Fix the ability to pre-determine a value placed in a "blank" cell. This is the "For empty cells show:" option

    Fix the ability to pre-determine a value placed in an empty cell. This is the "For empty cells show:" option on the PivotTable Layout and Format tab. Having the word "blank" show up is a crazy maker. I am using the work around of conditional formatting (;;;) but the software should work as designed.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

Feedback and Knowledge Base