Feedback by UserVoice

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

Welcome to the web version of Excel's feedback forum! This is the place for users to send us suggestions and ideas on how to improve. To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  8. Insert Pivot Tables on the iPad App

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

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  14. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    64 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    We 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.

  16. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  17. Pivot functions

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

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  18. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  19. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  20. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3
  • Don't see your idea?

Feedback and Knowledge Base