Note: (Excel and not Power Query)<\/p>\n\n\n\n
2. Choose Protect Workbook<\/p>\n\n\n\n
3. Ensure the Structure box is ticked<\/p>\n\n\n\n
4. Provide a Password (optional)<\/p>\n\n\n\n
5. Confirm by re-entering ( if password is supplied)<\/p>\n\n\n\n
This not only restricts access to queries but also stop any further way to get into the editor. The query tab in the Ribbon is greyed out and you so is the option to edit under Get Data. Below are two images showing the same.<\/p>\n\n\n\n NOTE<\/strong><\/p>\n\n\n\n Locking the workbook structure also locks the ability to slip into Power Pivot.<\/p>\n\n\n\n Another obstacle is that your structure of the workbook is locked, meaning you can not add, delete, or make any further structural changes to your file.<\/p>\n\n\n\n This is another set back!!<\/p>\n\n\n\n In case you use Power Pivot the answer sadly is no, else refresh works completely alright. Furthermore, when all your tables are on worksheets or as connections, the refresh works just fine. Yes certainly, but not very effective. And then create a new Table by Click on: Data<\/strong> > From<\/strong> Table<\/strong>.<\/p>\n\n\n\n What outcome is observed from the above steps and The above steps enable us to makes a new query based on the initial query you made. Following are the STEPS ; We take advantage of Protection Structure in Excel. This is where the magic begins, follow carefully: 1. Stay in the Excel File and go to Review TabNote: (Excel and not Power Query) 2. Choose Protect Workbook 3. Ensure the Structure box is ticked 4. Provide a Password (optional) 5. Confirm by re-entering ( if password is Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,18],"tags":[707,708],"class_list":["post-3299","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","tag-protect-power-queries","tag-protect-power-query"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3299","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3299"}],"version-history":[{"count":2,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3299\/revisions"}],"predecessor-version":[{"id":3301,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3299\/revisions\/3301"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3299"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3299"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"Power](\"https:\/\/excelinexcel.in\/ms-excel\/wp-content\/uploads\/sites\/2\/2020\/04\/Power-Query-Lock-1024x133.png\" "\\"Protect")
<\/figure>\n\n\n\n![\"Protect](\"https:\/\/excelinexcel.in\/ms-excel\/wp-content\/uploads\/sites\/2\/2020\/04\/Power-Query-editor-lock.png\" "\\"Protect")
<\/figure>\n\n\n\nDoes doing a Refresh work when you Protect Power Queries?<\/strong><\/h2>\n\n\n\n
If you have a single Power Query that lands in the data model, you are jammed. If Power Pivot is involved and you have protected Queries using the above method, then refresh fails.<\/p>\n\n\n\nIs there another trick ?<\/strong><\/h2>\n\n\n\n
Firstly carry out the steps like you normally do or wish to in Power Query.
Once you click OK, load the data as a table onto a sheet.
Click anywhere within that table (to stay within the table)<\/p>\n\n\n\n
Why is there a need to create another table?<\/strong><\/p>\n\n\n\n
The difference is that in the new Table, there is only one step, which is the \u201cSource\u201d step.
Any updates to the original query will reflect on the second (New) one when you press \u201cRefresh\u201d.
And there you get a table not protected but your queries aren\u2019t visible in the sheet anymore.<\/p>\n","protected":false},"excerpt":{"rendered":"