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. Bring Power Pivot closer to Power BI Desktop Functionality

    Development for Power Pivot for Excel seems to have stopped around 2016. TREATAS got added as a DAX function that works, but it never got added to Intellisense, and that was nearly 3 years ago.

    Today, the two measure editors (still no idea why there are different ones) are a very VERY poor substitute for the fantastic DAX editor in Power BI Desktop. It is a real pain to properly tab and indent in the Excel Measure editor(s).

    In the last year there have been about a dozen new DAX functions and several updated functions per https://docs.microsoft.com/en-us/dax/new-dax-functions but NONE of…

    63 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 →
  2. Multilevel Add/Remove blank row after each item in Pivot Tables

    I have a tabular form Pivot Table with four Row fields. I would like a blank row after the end of the first and second fields, but not afterwards. With the 'Add a blank row after each item' command, I get a blank row between every line of data, rather than having the lesser fields grouped together with no blank line. I would like to be able to select a field entry and have the command add a blank line at the level of the selected field.

    1 vote
    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 →
  3. Enable Pivot tables to automatically refresh after a query table or list object has updated - this is how Excel used to function until 2016

    Until Excel 2016 (I believe), Pivot Tables automatically updated after a query table had refreshed. With the removal of this functionality many of our workbooks have been affected after our move from Office 2010 to office 365.

    Can we please get this functionality back - not only did we use to rely on it, but in terms of a calculation chain, it makes perfect sense.

    See also:
    https://answers.microsoft.com/en-us/msoffice/forum/msofficeexcel-msoother-mso_o365b/excel-pivot-table-automatic-update/57ccd7dc-9ff7-4e5c-b892-ab18084b2738?messageId=7aafcff3-32c4-4883-a3e8-92b39831ad0f

    Thank you

    Richard

    5 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. Fix a cell with drop-down menu in order to move with a row after filtering in a PivotTable.

    It would be good to ensure that the drop-down menu (list) you create in a specific cell moves along with the cell while sorting the rows according to the filter you are using in the PivotTable. (Something like fixation using $).

    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 →
  5. Allow time format >24 h in Power Pivot and Power BI

    In order to calculate monthly call times, one has to create an overly complicated DAX formula in order to show the times above 24 h correctly. As a result, it doesn't function as TIME, but as TEXT, and one cannot use it in charts.

    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 →
  6. Crear Tablas dinámicas (pivot tablas) y modificarlas en IPad

    Debería ser posible crear y modificar Tablas Dinámicas en el iPad.

    Excel para IPad no sirve de mucho sin esta opción

    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. Add "Edit Measure" to right-click context menu for PivotTable Fields Values Pane

    When I want to edit a PowerPivot measure, I generally want to edit a measure I'm already using.

    I don't want to scroll through a whole bunch of tables in the fields list trying to find it. I just want to right-click on that Measure right from the PivotTable Fields Values Pane where I can already see it, and do it right from there.

    10 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 →
  8. "Ideas" - interface for customization confusing

    "Which fields interest you the most?" checkboxes are confusing. They appear to operate as toggles but with confusing indicators.

    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. solver with data model

    easy way to use solver together data model (do the calculation inside data model / faster)

    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 →
  10. power query fuzzy match

    Please include the option to show a similarity value for each match, as the Fuzzy Lookup add-in had it. Any time you do a fuzzy match you need to validate the results. Sorting by similarity make this much more efficient, you can ignore the 1.0's, and see if the threshold should be adjusted.

    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. Button to identify referential integrity errors in Power Pivot

    If the column on the "many" side of a relationship contains values that the column on the "one" side does not, then when the column on the "one" side is used in a PivotTable, an implicit (blank) will be used to represent these values. However, if a column that uses this (blank) is on the "one" side of multiple relationships, it can be difficult to find out which columns on the "many" side are causing the (blank) to appear.

    A measure can always be created to report the offending columns, but it would be error-prone because each relationship would need…

    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 →
  12. In Power Pivot, be able to move highlighted text by clicking and dragging it

    In any modern code editor, you can move code around by highlighting it and then clicking and dragging it. This is convenient because it can be done purely using the mouse and it avoids the use of the clipboard. Please bring this capability to Power Pivot.

    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. Show hidden tables in the Manage Measures window

    In the Manage Measures window (accessible from Excel's Power Pivot tab), only visible tables appear under the "Table name" dropdown menu. This means that no measure can be moved to a hidden table and no measure that is already in a hidden table can be edited without also moving it to a visible table. Please show all Data Model tables under the "Table name" dropdown menu.

    This is an issue only with the tables themselves. Hidden measures and measures in hidden tables appear just fine in the Manage Measures window.

    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. Percentile added to pivot table functions

    Please please please add the percentile function to Pivot Tables! I spend spend so much time manually calculating percentiles.

    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 →
  15. Please make "Insert Calculated Field" tab in PivotTable should be able to expand it. It is so small and inconvenient.

    Please make "Insert Calculated Field" tab in PivotTable should be able to expand it. It is so small and inconvenient. It is almost impossible to insert long formulas there or to insert fields with long names,

    6 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. Group all Data Model tables together in the PivotTable/PivotChart Fields pane

    Currently, the PivotTable/PivotChart Fields pane is broken up into 2 groups of tables: tables with no visible columns at the top and every other table at the bottom. Please further split these bottom tables into Data Model tables (middle) and tables exclusive to Excel (bottom).

    Only Data Model PivotTables and PivotCharts can use multiple tables, and the only tables that are useful in a Data Model PivotTable or PivotChart are those that are already in the Data Model, so they should be grouped together to make it easier to find them.

    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. Be able to access the Field Settings of a Power Pivot table column that is used in the Filters area of a PivotTable or PivotChart

    In a PivotTable or PivotChart, the Field Settings are accessible when you click on an Excel table column that is used in the Filters area. However, if the column comes from a Power Pivot table, the Field Settings will be greyed out. The cumbersome workaround is to put the column along the rows or columns of the PivotTable or the legend or axes of the PivotChart, modify the Field Settings, and then drag the column back into the Filters area. This makes no sense and turns something as simple as giving a field a custom name into a chore.

    Please…

    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. In Power Pivot, have an option to restrict filters on a column to a single distinct value

    Sometimes, a column is used for specifying a unit (e.g. meters, feet, $, £), specifying a way of calculating (e.g. average, maximum), or some other case where calculations will make sense only when a single value is selected. DAX has functions such as HASONEVALUE and SELECTEDVALUE to accommodate these cases. However, the user is still free to accidentally select multiple values for these columns, which can lead to confusion when nothing calculates.

    To help us enforce the intention of such columns, please give us an option in Power Pivot to force a column to be filtered to a single distinct value in…

    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. Allow the direct change in capitalization of PivotTable names

    If you try changing the capitalization within a PivotTable name directly, the rename will not count. As a workaround, you must give the PivotTable a new name that differs by more than just capitalization, and then rename the PivotTable again to the desired name. Tables and PivotCharts allow the direct change in the capitalization of their name, which makes PivotTables the odd one out.

    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 →
  20. Remove redundant buttons on slicers based on the number of distinct values

    When a slicer has only 2 values, the Multi-Select button is redundant, since all combinations of selections can be made by selecting a single value or clearing the filter. When a slicer has only 1 value, both the Multi-Select button and the Clear Filter button are redundant, since the filter cannot be changed. In fact, the whole slicer is useless, but that is another story.

    Please show the Multi-Select and Clear Filter buttons on slicers only when they are not redundant. This simplifies the user experience, reduces the visual clutter, and gives more room for the slicer's caption.

    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 →
← Previous 1 3 4 5 14 15
  • Don't see your idea?

Feedback and Knowledge Base