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.

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

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 $).

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.

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

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

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.

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

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

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.

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.

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.

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

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,

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.

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.

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.