With the tables, if the header is not visible, Excel displays the headers of the table in the columns headers (see the picture attached)

It will be great to have the same behaviour with the pivot tables

It would be very flexible to be able to deconstruct pivot table into basic worksheet. This should break the connection and all pivot table propertiies. Of course it would be irreversible.

It should be possible to name the new worksheet from the "load to…" function in Power Query. Any table that is created inherits the name of the query that produced it, but the worksheet always receives a default "Sheet1". For my purposes, inheriting the query name would be sufficient. Others may wish to name it from within PQ.

I inherited a pivot table tied to a private database. I want to keep the pivot table but change the underlying data source. This is currently impossible so I'm having to recreate the whole thing from scratch.

Filter arrows should be able to be hidden in all tables (including PivotTables). This is especially applicable when using linked tables in a PowerPoint presentation.

In the PivotTable Options > Display menu there is a checkbox for "Display field captions and filter drop downs". This should be split into two options: "Display field captions" and "Filter drop downs", with Filter drop downs having two sub-boxes: "Remove filtering" and "Show filter arrow when hovering". This would make the filtering arrow only appear when the curser was hovering over the box or it was the active cell.

Show Report Filter Pages also for Data added to the Data Model of Power Pivot

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.

Creation de table nouvelle dans powerpivot

Hi

I would either like the ability to put comments on individual cells within a pivot table (and eventually retrieve this)

Using PTs a lot to cross check and make notes about what needs fixing but filtering a long PT doesn't filter the associated rows outside of said PT to keep comments aligned

Allow pivot table to be independent - changing grouping etc. or even updating on one should be independent from the others. A common example is wanting different data grouping on different pivot tables.

Please show implicit measures in the Manage Measures window (which is accessible from Excel's Power Pivot tab) and label them as such. This would make it easier to find them for later migration to explicit measures and removal.

The quick explore feature is cute, but it destroys the shape and format of the pivot table. I can't have some uninformed user selecting that icon and screwing up the worksheet as the entire pivot table changes and morphs with the new filters. Crazy! Allow it to be turned off, just like the drill down feature (enable show details).

In the Pivot Table Field Settings - it's usually a pain having to always refer to the main field section to drop any column especially in the Value section where we have recurring details - hence the need to have like a tooltip drop down to change the columns not having to remove the former and then have to go drag and drop the next (e.g. in data involving daily sales in columns) - see image for clarity

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

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

HI MS

It appears as though the timeline slicers are breaking when there is a space in a blank cell. This is frustrating as it is difficult to fine because the cell appears to be blank. Can you fix this or do i have work around it a trim/clean formula?

There is a bug with hierarchy levels in the PivotTable Fields list with SSAS as a data source.

I have a tabular model with several dimension tables and hierarchies.
In the Excel PivotTable Fields list, I navigate to a hierarchy and expand the levels.
Right click on a sublevel, then a context menu allows to "Add to Report Filter", "Add to Row Labels" etc.
Doing this, Excel adds a field from another hierarchy from a completely different dimension instead of the selected one.
Possibly this depends on hidden fields in SSAS?