Joana

My feedback

  1. 2 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      Joana shared this idea  · 
    • 253 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        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

      • 126 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          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  · 
        • 92 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            Joana supported this idea  · 
          • 1,213 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              Thanks for the post Caleb. As some folks in the comments mention, you can change the format of the cell to Text before the paste. But even so, it’s clear that there’s some user pain around this experience. We hear you and we’ll evaluate how we can do a better job here. As always, we’ll spend the most time/attention on the things with the most votes, so please keep voting for things you want the most.

              Best,
              John [MS XL]

              Joana supported this idea  · 
            • 328 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                Joana supported this idea  · 
              • 2,079 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  563 comments  ·  Excel for Mac » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

                  Thanks to everyone who has voted for this suggestion. The title has been updated so that it mentions Power Query, but no longer mentions Power Pivot or Power Map. Please add your votes to separate suggestions for those features. Keeping the suggestions separate will help make the voting more meaningful.

                  Thanks – Steve K [MS Excel]

                  Joana supported this idea  · 

                Feedback and Knowledge Base