Feedback by UserVoice

Joana

My feedback

  1. 3 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Joana shared this idea  · 
  2. 232 votes
    Sign in
    (thinking…)
    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  · 
  3. 393 votes
    Sign in
    (thinking…)
    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  · 
  4. 2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Joana shared this idea  · 
  5. 741 votes
    Sign in
    (thinking…)
    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

  6. 105 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Joana supported this idea  · 
  7. 1,530 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks very much for your votes. And to those who took the time to fill in the survey, thank you! This is a brief update to let y’all know that we’ve started work on this feature request.

    - Urmi [Msft]

    Joana supported this idea  · 
  8. 516 votes
    Sign in
    (thinking…)
    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  · 
  9. 3,251 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

Feedback and Knowledge Base