Feedback by UserVoice

 

Ashvini Sharma (Lead Program Manager, Microsoft)

← Welcome to Excel’s Suggestion Box!

My feedback

  1. Marking values presented more that once in filter window

    15 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    6 comments  ·  Excel for Windows (Desktop Application) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ashvini Sharma (Lead Program Manager, Microsoft) commented  · 

    Hi Roman,

    I'm having trouble understanding this idea clearly to see whether Kenneth's input (which seem like the best solutions) are overkill or not. Seems like you have a range of cells where several columns together identify a unique product and you want to be able to operate on them as a group - change fonts/colors/summarize, etc.?

    Is it possible for you to describe in more details?

    thanks
    ash

    Ashvini Sharma [Microsoft Excel]

  2. Include Median in Pivot Table Value Field Settings

    265 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    24 comments  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    We’ve just merged two items that were both requests for the Median function in PivotTables. One had been for Windows, the other for Mac. When we get to this, we should actually make the addition on all platforms including Windows, Mac, Web, and others.

    An error occurred while saving the comment
    Ashvini Sharma (Lead Program Manager, Microsoft) commented  · 

    hi aikimark1955, it's just a matter of prioritizing what we work on, so getting votes on this item is actually helping us weigh the importance vs. other items..

    An error occurred while saving the comment
    Ashvini Sharma (Lead Program Manager, Microsoft) commented  · 

    While it's not possible in Pivot Table value fields settings today, Excel 2016 introduced a new MEDIAN function in DAX. Does this help?

  3. Allow the pivottable to not aggregate data (e.g. show values)

    63 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    33 comments  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ashvini Sharma (Lead Program Manager, Microsoft) commented  · 

    I received a response back from Sam on this that's more looking for supporting Text measures that propogate, where there's only one value for each value in the pivot table. Is this what others are looking for as well?

    thx
    ash

  4. Have a new "database" sheet type which runs super fast

    9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    5 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ashvini Sharma (Lead Program Manager, Microsoft) commented  · 

    Hi Levi,

    Thanks for the response. Since you're familiar with the Table viewer in Power Pivot, wondering how the functionality of the "database" sheet type would be different than that capability. I.e. is the request a matter of hosting that experience as a new sheet tab in Excel? Or would that still be too much?

    thanks
    ash

    An error occurred while saving the comment
    Ashvini Sharma (Lead Program Manager, Microsoft) commented  · 

    Hi Bill,

    Have you looked at the 'Data Model' and Power Pivot capability of Excel 2013 and later? It's designed to scale to much larger datasets than the grid, and support joins, calculated columns & measures..

    Would love to hear of your experience with it

    thanks
    ash

  5. Go Away with limitations on Number of Rows and Columns

    14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    5 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Ashvini Sharma (Lead Program Manager, Microsoft) commented  · 

    Sanjib, Data Model in Excel 2013 and beyond is designed to support large number of rows. Have you already tried it out and found it lacking? How so? I'm curious what your scenario is where the number of columns is restricting.
    '

Feedback and Knowledge Base

(thinking…)