How to hide the queries and connection in Excel

mrchonginhk

Well-known Member
Joined
Dec 3, 2004
Messages
672
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
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
3,287
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:

Forum statistics

Threads
1,078,240
Messages
5,339,038
Members
399,275
Latest member
amrita17170909

Some videos you may like

This Week's Hot Topics

Top