Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Excel for MAC - how to lock hidden tabs without disabling Get Data (Power Query)

Copper Contributor

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 (Power Query) --> Launch Power Query Editor" function.  That function is necessary for the spreadsheet to work because the user has to upload data files into Power Query Editor to run the calculations in the spreadsheet.  

 

Is there a way that I can lock hidden tabs so that a user cannot access them without locking the full workbook?  Alternatively, is there a way to Protect Workbook without disabling the Launch Power Query Editor function?  

 

Please note that this is Excel for MAC.  

 

Thank you for the help.

1 Reply
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..