I've seen locked sheets used as data source for constants and formulas with variables, the cells reference those with lookups and variables.
I've come across a few spreadsheets that made me want to meet and learn something from the authors. Some have been very elaborate and surprisingly resilient.
I've come across a few spreadsheets that made me want to meet and learn something from the authors. Some have been very elaborate and surprisingly resilient.