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.

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.

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

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.

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

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

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.

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.

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!

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

The Pivot table is the most powerful tool in Excel and with Office 360 I am finding it difficult to connect the pivot to a SQL DB query easi

I bought a Chromebook and was expecting to use Microsoft Office excel,word, Powerpoint, etc. but to find out that this is a lite/soft version of the actual Microsoft Office, I should of bought a regular computer

54hesh5ltuog;ze

Excel Online needs to be able to have full Pivot Table functions - we need to use excel online for sharing in the team but are frustrated without the ability to drill down!