Excel for the web
Update: Microsoft will be moving away from UserVoice sites on a product-by-product basis throughout the 2021 calendar year. We will leverage 1st party solutions for customer feedback. Learn more
-
Provide a better way to display dates in a pivot table drill down result
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
1 vote -
The right click Show/Hide Field List option on a pivot table is not saving.
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.
28 votes -
Calculated Field with Pivot Table in Excel Online
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.
1 vote -
Pivot Forms as a new function Excel-Online as well as on the desktop version
Since MS Access is now being degraded it seems to me a compact and basic program like Excel should have a function where you can easily create "forms" (as in datafields) based on a Excel-table.
Why not create a function that works in the same way as pivot tables or pivot charts, but then as a pivot form. Where one record from a table is being displayed in data fields based upon the column of the table record.
And off course that you can easily change, add and delete records in and from the excel table through this Power Form.
…
1 vote -
Power Pivot: Enable users to reference data model tables and columns in the Excel's main formula bar
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.
1 vote -
Value field In a Pivot Table
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"
1 vote -
Allow Double Clicking Pivot Value to open records in new sheet
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.
11 votes -
Insert Pivot Tables on the iPad App
On the iPad app, we need to be able to insert pivot tables.
4 votes -
in the pivot table online version there does not have design and pivot table analyze function and
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 .
5 votes -
allow show detail in pivot tables online. I don't understand why microsoft makes it so hard to do basic functions.
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
3 votes -
Excel Power Query
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
4 votes -
Allow Edit on PivotTables Data Values
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.
1 vote -
Please add see details to the pivot table
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.
1 vote -
2 votes
-
PivotTables created with Power BI using Analyze In Excel should work after publishing to Power BI
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!
684 votesWe are working on enabling connectivity from Excel on the web to Power BI. When this work is completed, a PivotTable that is connected to a Power BI dataset will be fully interactive when displayed in Excel on the web. It won’t matter how the PivotTable was created, whether by Analyze in Excel or in some other way. We look forward to implementing and deploying this capability, but I am not yet able to commit to a delivery date.
-
Enable refresh to pivot tables when sharing is active.
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.
2 votes -
Pivot functions
Would be much better with :
1) Slicer features
2) advanced graphical functions3 votes -
1 vote
-
1 vote
-
1 vote
- Don't see your idea?