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. Add versatility to Report Filters for pivot table date fields

    Currently, the Autofilter function for spreadsheet tables, when used on a date field, allows for selection by year, month, day, or even prescribed ranges; but Report Filter for pivot tables only allows selection by day. Please add the same date filtering capabilities for pivot table Report Filters as are available with Autofilter.

    2 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 →
  2. Synchronized attributes in Pivot Table's report filters

    I would like to drag attribute from a hierarchy into pivot table's report filters, as it can be done through Slicer.
    In such way I will have synchronized attribute (e.g If I have Year and Quarter into report filters and I filter Year=2016 I will see into Quarter's report filter only quarters belonging to 2016).

    Thanks!!

    2 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 →
  3. How to lock shapes that surround a pivot slicer but don't disable slicer

    I have a dashboard where I have shapes that surround my slicers to make it more visually appealing. I don't want the end user to move or edit the shapes and the slicers. I've also grouped the shapes and slicers together.

    When I select the area that surrounds the shapes and slicers I use the 'review' tab and then select protect worksheet. Inside the protect worksheet dialog box I have selected the following:

    Select locked cells
    select unlocked cells
    Use Pivot Table & PivotChart

    I've also gone into the 'Format Slicer' options and under Position & Layout I've selected 'disable…

    4 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 →
  4. Data connectivity with Oracle

    Currently data connectivity with oracle is nightmare. Please make it easier for novice enterprise users

    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 →
  5. Add a Blank Field to Pivot Tables

    How many times have you had to copy and paste pivot tables to get them to look aesthetically pleasing because you need to enter in blank columns? By allowing for a "blank" column field to be added into pivot tables, you can take out the extra steps of making the pivots look pretty and can leave them in their native state.

    2 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 →
  6. Confidence Formula for Pivot Table

    All the values needed to calculate the confidence are currently available in Pivot Table functions, but the Confidence itself has to be manually written. It would be great to have that natively available.

    2 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 →
  7. manage pivotcache to reduce file size

    to used the same pivotcache for pivottable, to correct the misallocations

    Printing or reading allocations like relations in Access

    2 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 →
  8. Top 10 filter + extra selection of your choice

    It is not possible to compare some item in a group with the top x of the that group in the same pivot table. It is useful to give some context to that that item when we produce reports. e.g. top 10 economies by GDP + the GDP of Cameroon.

    2 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 →
  9. Direct Query to Azure SQL Database, Azure SQL Data Warehouse, SQL Server

    I want to connect Azure SQL Database, Azure SQL Data Warehouse, and SQL Server by Direct Query of Data source.

    4 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 →
  10. expanding more dynamic with grouped items in pivot table.

    I have many reports where I would like to group by month, quarter and year. I would like the ability to expand one of the years to months while leaving the other years showing Quarters. Today when I expand a quarter, it expands it for all years. Yuck!

    2 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 →
  11. Editing calculated fields from the PivotTable Fields pane & renaming calculated fields

    It has always confused me that I can see my calculated fields in the PivotTable Fields pane but cannot edit them from there. Instead, I have to go "Analyze" tab, "Fields, Items, & Sets", "Calculated Field", and choose the calculated field from the dropdown list. We should be able to add, modify, and delete calculated fields from the PivotTable Fields pane, perhaps through a right-click menu.

    We should also be able to rename a calculated field. Currently, if you "rename" a calculated field, the "Modify" button becomes "Add". In other words, to rename a calculated field, you have to add…

    2 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. Fix the problem with multiple Groupings on the same field in Pivot tables

    Until Excel 2003 the Pivot Table Wizard asked the user if he/she would like to keep the new pivot table independent from the others (separated data cache). This allowed i.e. to create different groupings on the same field. Starting from Excel 2007 this option has disappeared from the pivot creation gui interface. Please re-add it.

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

    We’ll send you updates on this idea

    2 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  13. slicer and time axis should effect each other

    I use a PivotTable with a slicer for years and a time axis with months, quarters and years. Slicer and time axis have no effect in filtering each other. If I choose a range in time axis, the slicer should be filtered, too. And also using the slicer should effect the Settings in the time scale / axis.
    Thanks ;-)
    Andreas

    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 →
  14. Slicers - override the pick list

    Slicers are a great addition! Currently, slicers get their pick list from the Table / Pivot Table, of course. I'd like to be able to override this with a list of my own - from a range of cells.

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

    We’ll send you updates on this idea

    4 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  15. Slicers - Events

    Add Events to Slicers - like ActiveXControls

    8 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. Grouping in Power Pivot reports

    To be able to use Grouping in Power Pivot reports as is works in Pivottabels.

    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 →
  17. Go to Pivot table name

    If I give an Excel-table a name, then I can use the Go-To function to find it. Why can’t I find named Pivot tables in the same list?

    4 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 →
  18. Pivot Table Calculated Item

    It is observed that the pivot "calculated item" feature has two serious drawbacks:
    (1) The calculation takes a long, long time compared to "calculated field" feature.
    (2) The calculated numbers generated via "calculated item" on the pivot table can be altered or defaced which does not happen when "calculated field" feature is used.
    The above drawbacks render the use of "calculated item" in pivots unusable. Can we address these?

    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 →
  19. Change default calculation for pivot table items

    When I drag new items into the values section of a pivot table, they always default to the 'Count' calculation. In my work, it's almost always 'Average' that I want though, and I'm left dragging a bunch of items in and changing them one by one in the dropdown. Annoying.

    So, I'd ask you to consider adding one or both of the following options:
    1. Change the default calculation for newly added items
    2. Allow changing of calculation for multiple items at once (this would be particularly good if it let me change all the options for multiple items together)

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

    We’ll send you updates on this idea

    2 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  20. Please fix the bugs in pivot tables! (I am only using XL2010 so far).

    There are loads of bugs and omissions in Pivot Tables (maybe already solved in the latest version).


    1. If the data source range is updated to zero records (ie only the one row of column titles), Excel gives a useless error message and then displays the previous dataset's results instead of an empty pivot! Not only is this a potential security risk in a multiple user situation, but it means that all pivot table code has to be surrounded by workround code to add a null record to the range so that it doesn't fail.


    2. If you double-click on a pivot…

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

    We’ll send you updates on this idea

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

Feedback and Knowledge Base