Re: Confidential data to be used in calculations in public workbook
Thanks John, makes perfect sense to me.
I guess what I will propose is:
- Store the table inside the file (very-hidden, protected, etc, for what is worth). I will encrypt it with some simple two-way logic.
- Put the calculation and the decryption step inside a pwd-protected UDF
This should discourage most smart users. If still too weak, I will mention the DLL option, but we are out of my zone here. Thanks very much for mentioning this.
Can I assume the only “correct” solution would be to have a server side layer, built with whatever tool?