Feedback by UserVoice

Joana

My feedback

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

      Joana shared this idea  · 
    • 1,731 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 wanted to share with you that the new query caching mechanism in Excel has been deployed to Office Insiders starting from Excel version 1801 (build 9001.*). At this stage, we would like to allow some “baking” time as we monitor the feature health metrics.

        In this scope, we need your help to ensure a quality release! I encourage you to try the following scenarios and share your feedback:
        1. Run Refresh All on a complex workbook with multiple query dependencies. Does it work faster?

        2. Run Refresh All on a complex workbook with multiple query dependencies. Do you see any issues with your data?

        3. Refresh a single query several times. Do you see any issues with your data?

        - The Excel Team

        Joana commented  · 

        Please Microsoft!!!!!!!!

        The developers were already crazy with the functionalities included in the different 365 packages (PRO, E3, standard, home, MSO ...) but if we add the channels .... Each client we have has different version in the packages and of course different channel version.

        All this, as you can suppose, takes hours to try to investigate where the problems are.

        When the files are shared, it happens that they are edited by different users that have different versions and, of course, different channels (the new buzzword), all this leads to MANY problems of various kinds.

        I beg you, to facilitate the work of the people who develop solutions with your tools that we consider fantastic and that we recommend our clients to continue using.

        Thank you

        Joana supported this idea  · 
        Joana commented  · 

        Please urgently needed !!!!

      • 178 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 Joana & others,

          Thanks for logging this suggestion. Yes, being able to protect your queries would be quite useful indeed for delivering solutions. We’ll prioritize this based on the interest, so if you’re reading this and haven’t voted as yet, please do so.

          thanks

          Ashvini Sharma
          Lead Program Manager
          Excel

          Joana commented  · 

          Hi Ryan, the problem is that locking the workbook structure with password data can't be refreshed, also the Queries can be copied to another workbook.
          Anyway, thank you very much for your interest in the subject

          Joana commented  · 

          Hi Carl,

          Of course, we use both Excel and Power BI. But with Excel environment only, is not possible to protect the Queries.

          The point is, as well as you are able to protect the formulas, VBE, … and any other modifications in an Excel workbook, why this is not possible with Power Query.

          Of course in some chats they explain how to do it, for ex. (http://stackoverflow.com/questions/37444536/how-to-password-protect-power-query-queries), but I think that the tool should let the users to do it without such alternative ways.

          Thanks

          Joana commented  · 

          Sure I have not explained well in my request.

          Power Query queries are basic in the data model that later on is designed, any change on the queries can affect decisively on results and may even cause it to stop working.

          Of course the connections can be protected in Power Query, they already have password as they have in the source systems.

          What I ask for, is that when a file (which has a data model created with Power Query) is distributed to the users be able to protect the queries from users modifications.

          If users want to learn Power Query no problem, it is possible to send the unprotected Queries to practice. But when you send official reports which have important data and measures to the users they should not practice with that.

          I have had already problems on this subject.

          Thanks

          Joana shared this idea  · 
        • 341 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 Ken,

            Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

            thanks
            ash [MS XL]

            Joana supported 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

              Joana shared this idea  · 
            • 450 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

                Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

                Thanks

                Ashvini Sharma
                Lead Program Manager
                Excel

                Joana supported this idea  · 
                Joana commented  · 

                I would like to add that it shlould be also allowed to modify the tables in protected sheets via VBA.

                Now you can't, even if when you protect the sheet with the VBA option UserInterFaceOnly: = True.

                To be able to work with tables, through VBA, we have to unprotect and protect the sheets each time.

                Thanks

              • 98 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

                  Joana supported this idea  · 
                • 1,333 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

                    Joana supported this idea  · 
                  • 475 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

                      Joana supported this idea  · 
                    • 2,544 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

                        688 comments  ·  Excel for Mac » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
                        Joana supported this idea  · 

                      Feedback and Knowledge Base