I've created a large excel file with many pivot tables from a single data source. I used macros to auto update pivot filters. The pivot data values show different values to the selected filters. When I double click on the data values it opens up source data in a separate worksheet with rows different from the selected filters.

Please see attached screenshots.

I can better explain this if you could call me back/arrange for a video call.

Thanks

The right click Show/Hide Field List on a pivot table does not save. My field list keeps coming back, even though I have set it to Hide.

I use pivot tables daily and often have to drill down into the data to understand some additional details or context but one annoying 'feature' is that the date column is never expanded to display the whole date.

Please could this be looked at as it is very frustrating to have to resize the field every singe time I drill down.

Thanks

When I use Excel Online, I am not able to add a calculated field for my pivot table. This feature already exists in Desktop version, adding this feature to Excel Online would help.

Please give us the ability to use data model tables and columns in VLOOKUP/XLOOKUP functions. That would be so nice!

The data model is really useful but all we can do with it right now is create pivot tables and charts. Adding this feature would allow Excel users to use the data in the data model in a customized way and without having to load all the data into a Excel sheet in the workbook.

Cube value functions are complex, they also don't work when trying to fetch text columns.

In Value Field in a Pivot Table there are various options of calculation of that field . At times one may not require calculation but to display the values as in source Cell. so in calculation option one more option may be added "same as Source Cell"

In the offline version of Excel, you can double click a value in a pivot table and it will create a new sheet with the associated records.

On the iPad app, we need to be able to insert pivot tables.

in the pivot table online version there does not have design and pivot table analyze function and when you right click on the Pivot table there have not choice of function .

Why does microsoft want customers to step back into the 1990s for the online version. it degrades your brand. Show details in a pivot table is very basic. And its not on your joke of an online version

Make it possible to match two sets of data using more than one reference column ,for example, if table1 has columns Bar Code, Description and Cost and table2 has columns Date, Bar Code and Cost, it should be possible to match the two data sets say using Bar code and Cost columns

Currently it is not possible to edit the data on a pivottable in Web.
There is a property enableDataValueEditing which nly works on Windows but not on Web Excel.

We have a requirement were the user makes edit on the pivot and then via the worksheet change event we update the data source (table on another sheet) and then refresh the PivotTableso so that the changes are preserved.

Please for the love! Add "See Details" to the online version of excel. In fact, just make the desktop version the online version. Desktop is the best and would make everyone so happy.

Power BI's Analyze in Excel functionality allows Excel users on the desktop to create reports using PivotTables and cube formulas connected to a published Power BI dataset. However (and this is very hard to explain to customers) these reports only work on the desktop: even though Power BI allows you to publish Excel workbooks to an App Workspace, reports created using Analyze In Excel do not work after they have been published to Power BI because Excel Online does not support connections to Power BI. Please fix this!

Enable or allow users to refresh pivot tables while in shared mode. That way, teh group can ge the best reports, without losing history. Necessary in any environment where shared excel files are used.

Would be much better with :
1) Slicer features
2) advanced graphical functions