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

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,444
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,099,787
Messages
5,470,769
Members
406,720
Latest member
tylergaps

This Week's Hot Topics

Top