Forum Discussion
Excel help - protecting sensitive information in model
G'day, I was hoping for some help / guidance around the best way to secure/protect IP within an excel model. The idea would be that other users are able to obtain outputs from a model based on a ...
Matt
The first question that comes to my mind is: What is so special about the formulas? Because every function that is used is known.
Password protection is merely used to ensure that nobody destroys formulas by accident. Password protection can be removed easily.
The best way to protect the model would be to develop it as an Add In. But there is always the possibility of reverse engineering.
The mathematical operations themselves are not complex or information sensitive - it is more how inputs are manipulated using various calculations as well as the fixed parameters within the model (that are also used within the model calculation) that I'm trying to protect.