Hi Friends-

This may not be in the exact right place but I'm hoping for a little grace.

I have a very data sensitive workbook that needs to be protected. The file will be move to sharepoint as a read-only file, during our testing the file drop downs are disabled, no matter what I do to the file to keep them live. The whole workbook is dependent on the drop down menu working- without that feature it becomes a dead file.

Does anyone have any guidance or advice on how to keep the sensitive data protected on sharepoint but that will enable the dropdowns?

Thanks-