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 box to specify name for PivotTable at creation, rather than after

    When adding a PivotTable (or the non-Pivot variety of table for that matter) it would be helpful if the box that confirms which data you want and where to place the table would also allow a name to be specified at this point.

    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 →
  2. How about a way to refresh my pivot table from my iPad when Excel believes it will overwrite adjacent cells. The Pivot Table filters data.

    I can only refresh my Pivot Table after adding data to my data source from my laptop computer. My tablet and iPhone will not allow me to do this because it says I would overwrite adjacent cell. The Pivot Table is only a compilation of the data in a separate work sheet. so overwriting adjacent cells poses no problem at all. Even if you wanted to display a warning dialog box, that would work as long as I can tell Excel to go ahead and refresh. (Of course, auto refresh would be an even better idea.)

    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 →
  3. Allow slicers on protected sheets to be USED but not edited

    When we protect a worksheet, we can choose whether to edit objects.

    ...If we uncheck this box, slicers can't be used. They become useless decoration.

    ...If we check this box, slicers and all other objects on the sheet, can be selected, moved, resized, and deleted.

    Please allows us to protect our objects while also allowing us to use our slicers.

    11 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. Pivot Table

    In Pivot Table, Group By option should allow to define the start and end date for "Year", "Month" or "Week"

    - Month start date is 26th of previous month and end date is 25th of the current month
    - Week start day is "Friday" and end date is "Thursday"

    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 →
  5. pivot formula for calculated field working with specific columns

    From the documentation of power pivot it seems possible to have a formula like this:
    = [column3] - [column2]
    This is also known from some BI tools

    It would very appriciated to have this same method to work with for calculated fields in an ordinary pivot.
    From time to time it is just necessery and also sometimes faster to do it like this then mess around with other methods or do the calculations outside the pivot.
    I

    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. pivot, text in value fields

    Please make it possible to handle text in value fields.
    This will be a nice feature in some instances where you need to plot text values in a matrix.
    As an example for a work schedule it would be nice to have hours downwards, days horisontally and then have the pivot plot names of employess in the matrix.
    Also see this example https://www.youtube.com/watch?v=7_YvOpjUBNQ&t=384s

    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 →
  7. In DAX, generalize the aggregation iterator functions (SUMX, MINX, etc.)

    There are many aggregation iterator functions in DAX (SUMX, MINX, etc.). Their concept is the same: evaluate an expression for each row of a table and aggregate the results.

    Instead of blowing up the function list with functions like these, there should either be a generic aggregation iterator function that accepts the aggregation function as an argument, or a generic iterator function that covers the iteration step but not the aggregation step (i.e. it returns a list of values to be fed to the "normal" aggregation functions).

    The functions would look like this:
    AGGREGATE(AggregationFunction, Table, Expression)
    X(Table, Expression)

    So instead…

    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 →
  8. Allow the direct change of capitalization of measure names

    If you rename a measure, and you only changed the capitalization of some letters (e.g. rename a measure called "Test" to "test"), Power Pivot will throw an error saying that a measure or column with that name already exists. This happens in the measure grid in the Power Pivot window and in the Manage Measures window. The workaround is to rename the measure to a temporary name where more than the capitalization is changed, and then rename the measure to the desired name.

    Please fix this issue and allow capitalization of measure names to be changed directly.

    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 →
  9. edit data from pivot table

    Give me the ability to edit the source data from pivot table (instead of opening a copy).

    This would be huge b/c it would open up using Pivot Tables as a flexible UI, not just analysis.

    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 →
  10. timeline slicer - hide items with no data

    For "regular" slicers, there is an option to either visually indicate items with no data, or hide items with no data. For timeline slicers, no such option exists. It would be nice if the timeline slicer would gray out years/quarter/months that are not in the underlying data set.

    11 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 →
  11. Expand Pivot Tables without overwriting existing data beneath or to the right of table

    With all the queries on the internet, we assume there is no built-in option to prevent pivot tables from overwriting data beneath the table during refresh and expansion. Is that correct?

    Given that Excel has options for 'inserting' rows, why in the world would Microsoft NOT provide a pivot table expansion/contraction option for inserting or deleting rows from within the refreshed table without overwriting data beneath or to the right of the table?

    It is also interesting that inserting rows into a regular Excel table, using the TAB key in the last row, can add rows by expanding the table…

    27 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 →
  12. Pivot Table, extract data to sheet or view seleted data set to amend.

    When in a Pivot Table and you double click on a number, Excel returns an additional sheet with the data. New feature - Create an option, perhaps right mouse click, to give you the option to view the data in the data set or return the additional sheet with the data extracted.
    Thanks
    Alan

    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 →
  13. Select Data from Pivot Chart as well as Pivot table

    When the data from a Pivot Table is also shown in a Pivot Chart, can there be a 'feature' that can 1) Highlight the number in the Pivot Table when selecting a single or multiple data sets in the chart .. and ….2) report the data when double clicking on the chart area rather than double clicking on the number in the Pivot Table.
    Thanks Alan

    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. Show pivot table total above heading

    Often there are hundreds or thousands of rows in a pivot table. To see the column total we need to scroll to the bottom of the report. Please add an option to show the column totals above the headings

    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 →
  15. Create a formula to Display Data Source of Pivot Tables

    I work with numerous pivot tables within one worksheet. Some have the same data source to generate the pivot table and some do not. It would be extremely beneficial if there was a way to display the source of the pivot table within a cell to use as a reference value. So create this either by a separate formula that displays the source criteria or if that is too difficult, maybe just allowing this to be a feature of the PivotTable Options and allow to 'show source' at the top of the pivot.

    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 →
  16. Add "Change Source Data" button to context menu for pivot table cells

    Simply add a button to the right-click context menu for cells in a pivot table to refresh the pivot table. Having to go up to the ribbon (or Alt hotkey) is annoying.

    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 →
  17. In DAX, allow variables to be named "Dimension"

    In DAX, you cannot have a variable named "Dimension", despite "Dimension" not being a keyword or the name of any function. Please allow variables to be called "Dimension", or if this is not feasible, at least add this restriction to the documentation.

    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 →
  18. In DAX, allow comments to exist at the beginning and end of a measure

    Currently, if you try to add comments to the beginning or end of a measure, the comments will be silently removed when the user is done writing/editing the measure.

    For example, in the measure below, the //1 and //3 are removed.
    Test:= //1
    (

    0 //2
    

    ) //3

    Interestingly, if you have a calculated column that is written similarly, such as the one below, then no comments are lost.
    = //1
    (

    0 //2
    

    ) //3

    Please fix this issue.

    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 →
  19. Excel should add automatic "Dashboard" templates design as an option in its template area

    Excel should add automatic "Dashboard" templates design as an option in its template area

    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 →
  20. Select Pivot Table by name

    I would like to have the possibility to select a PivotTable by name.

    In a PivotTable chart, the source tells you what is the PivotTable name but then, you have so select all your PivotTables one by one to find the correct PivotTable.
    So if you can add a tool that is able to select a PivotTable by name, it will save a lot of time.

    Thanks

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

Feedback and Knowledge Base