Feedback by UserVoice

Peter Bartholomew

My feedback

  1. 473 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      Hi all,

      I’m happy to announce that your input has had another direct impact on the product. In this case, a decision has been made to have Power Pivot be available in all Windows editions (“SKUs”) of Excel! This means the Business, Home, Standard, etc.. all of these will have Power Pivot. As your comments have indicated, Power Pivot has moved from targeting a specialized audience to generally useful capability for working with data in spreadsheets. As such, it makes sense to make this as broadly available as possible.

      We have started rolling this change out with the April Current Channel updates (Builds 9330 and beyond). I’m also happy to announce that these SKU changes will be reflected on the upcoming 2019 version as well.

      Thank you for pushing for this!

      Ashvini Sharma
      PM Manager
      Excel

      Peter Bartholomew commented  · 

      Good news! Perhaps now, at last, spreadsheet programming will begin to move towards something more professional.
      Peter Bartholomew

    • 9 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        Peter Bartholomew commented  · 

        Fully agree. The ability to create an index array is fundamental to the process of building solutions in Excel using it as one would a program. It exists in Power Query and should exist as an Excel worksheet formula. I could also see myself using it in the form

        = SEQ( 1, ROWS(myArray) )

        assuming the function defaults to give vertical array.
        The simplest form

        = SEQ(5)

        should be interpreted as giving {1;2;3;4;5}

        Peter Bartholomew supported this idea  · 
      • 4 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          Peter Bartholomew shared this idea  · 
        • 2 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            1 comment  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
            Peter Bartholomew commented  · 

            If you wish to see an independent assessment of some models build using Names and Array formulas only go to

            https://sites.google.com/site/beyondexcel/project-updates/multi-cellarraymodelling

            Despite the simplicity of the approach, changing the array dimensions to accommodate further time periods (for example) is still a pain and the arrays have to be adjusted one by one. The insertion of additional rows through an array formula is trapped as an error despite there being no ambiguity inherent in the process.

            If one could simply use a resize handle (as is done for Tables), all the tables linked to a given index could be automatically resized, so removing a significant source of error.

            This will never be implemented by popular demand. It is up to Microsoft to show leadership as they did for the implementation of Tables in Excel 2007 or the more recent Get and Transform that is aimed at supporting data analysts, as opposed to modellers.

            Peter Bartholomew shared this idea  · 
          • 7 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              Peter Bartholomew supported this idea  · 
            • 72 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                Peter Bartholomew commented  · 

                Full screen would be good. Even then, for a 1000x100 array formula, seeing just the first few rows/columns and the last would be good enough. It is unlikely that I would wish to check all 100,000 values.

                Peter Bartholomew supported this idea  · 

              Feedback and Knowledge Base