Feedback by UserVoice

Excel for the web

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

    561 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    50 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  2. Refresh PowerPivot Data in O365 Excel from External Source

    It is frustrating to me that external data refresh is supported in Excel Services in SharePoint but is not supported in Office 365. It is frustrating that to work with any external data you must open the workbook in the desktop client.

    21 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    info needed  ·  Anonymous responded

    Did you know that you can actually refresh workbooks in Office 365 when you publish them on PowerBI? Try it out at www.powerbi.com

    Is that what you were looking for?

    If you have specific external sources that you are missing, please provide more specific information

  3. Excel Online Auto Refresh Azure Analysis Services

    Excel Desktop PowerPivot Report connected to Azure Analysis Services Tabular model refreshing the data works in Excel Desktop.
    However, when you publish this workbook to Power BI workspace (from the workbook's ribbon menu > File > Publish > Publish To Power BI) then you try to refresh the data in Excel Online it doesn't work!!!

    Microsoft should fix this limitation otherwise what's the point of having a refresh capabilities for just Excel Desktop PowerPivot.
    We want our end users to be able to refresh powerpivot reports Online.

    19 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  4. Access On-Premise cube from Excel Online

    We are interested in creating Analytical reports (pivot tables with slicers) with Excel and host in Excel Online against our On-Premise MOLAP and/or Tabular Analysis Services cubes. Looks like to do this with Excel Online, a powerpivot model would need to be in the Excel Workbook. We'd like to create several Analytical reports against the same cube On-Premise (or access a common Power BI dataset).

    Today we have Analysis services MOLAP and Tabular models hooked to Analytical reports hosted in Sharepoint 2013 On-Premise. Users can slicer/dice and drilldown.

    We are looking for this same functionality in Excel Online. Many of…

    19 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  5. Integrate Office Online Server with SSRS

    Integrate OOS with SSRS in native mode to allow publishing Excel reports and Power Pivot models to SSRS 2016.

    19 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  6. Include PowerPivot with Office 365 for Business

    Include Power Pivot with Office 365 for Business subscription

    17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  7. 14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  8. Powerpivot Slicers for Excel Online

    I use CUBEVALUE excel reports based on powerpivot data and with slicer. Slicers does not work on Excel Online.

    13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  9. We need to be able to have full Pivot Table function in Excel online.

    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!

    11 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  10. Pivot Tables that actually work

    Currently we're able to create a PivotTable in Excel 365 with ease. The trouble is with updating the data range or when the Data fields need to be extended. There are limited controls to access the normal pivot table Analyze & Design ribbons as within Excel Application.

    7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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. Office 365 Cloud - Allow creation of Power Query, not just refresh connection

    Office 365 - Cloud - Enterprise.
    Allow users to create Power Query queries, not just refresh a connection.

    6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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. Regarding Pivot-Chart

    creating a pivot-chart is not supported in Browser, I thought should allow the user to create pivot-chart.

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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. Require Pivot, Conditional formatting.

    Pivot, conditional formatting are required. Filter requires a lot of time, it should reduce. Reduce time delay

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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. calendar order

    Great that you have automatic date group in excel 2016, but it is calendar ordered. While it can be the default, there should be functionality to allow user to modify. Not everyone has the same fiscal quarters and year ends.

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  15. I'd love to have a median function directly in pivot tables/charts...

    i.e. change value field settings from "Sum of xxx" to "Median of xxx" where count, min, max, average, etc. already exist. It's possible to do via cubset/cubevalue and MDX but it surely must be easy to implement directly.

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  16. Pivot Table Right Click options to Expand/Collapse Entire Field

    Pivot Table Right Click options to Expand/Collapse Entire Field

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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. online version need to add power pivot and slicer

    online version still needs more enhancement to add power pivot and slicer.

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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. PivotTables based on multiple consolidated ranges

    it would be great if dropbox supported PivotTables based on multiple consolidated ranges

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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. Pivot Table Sheet/Tab Grouping

    Pivot Table Sheet Grouping - Group Pivot Table Sheets (Consolidate) similar to Web Page Menu Dropdown. Allow to group different types of Pivot Table Reports(Sheets) into expanding Vertical Sheet Tab (i.e. - Group Sales Reports, Employee Reports, Accounts Payables, etc...) How to group sheets - Use Ctrl and drag sheet within another sheet

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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. Re-open Pivot Tables!

    So sometimes people misclick and accidnetally close and lock pivot tables, and after that point they are completely useless for adding new information into. There should really be a way to reopen them as this is currently causing an information entry issue at my work.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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
  • Don't see your idea?

Feedback and Knowledge Base