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
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      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 →
      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]

    • Include Median in Pivot Table Value Field Settings

      70 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Forgot password?
        Create a password
        Signed in as (Sign out)
        Close
        Close

        We’ll send you updates on this idea

        17 comments  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
        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..

        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?

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

        25 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          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 →
          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

        • Have a new "database" sheet type which runs super fast

          9 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            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 →
            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

            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

          • Go Away with limitations on Number of Rows and Columns

            9 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Forgot password?
              Create a password
              Signed in as (Sign out)
              Close
              Close

              We’ll send you updates on this idea

              4 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
              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…)