Forum Discussion
Excel for MAC - how to lock hidden tabs without disabling Get Data (Power Query)
Hello, I have built a spreadsheet that relies on calculations performed in tabs that I need to hide and lock to protect my IP. However, when I "Protect Workbook," it disables the "Get Data (Powe...
I think you should create queries that the user does not need to edit, tie the user-editable pieces to named cells and get the value from those cells in your query..