How to hide the queries and connection in Excel

mrchonginhk

Well-known Member
Joined
Dec 3, 2004
Messages
679
I created several PowerQuery but I want to hide it.
Now, everyone clicking Data > Query and connection can find it.
How to make it "invisible" to others ?

Thanks
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,772
Review - Protect Workbook
but after that check if your result tables will work

edit:
but this is very illusory protection because they can simply copy the M-code without opening the PowerQuery Editor
this is only against changes in queries
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,102,291
Messages
5,485,973
Members
407,523
Latest member
Talicius

This Week's Hot Topics

Top