How to lock down HSGETVALUE
Summary:
Would like to lock down (hard-code / copy-paste) all "HSGETVALUE" formulas, without locking down all the other formulas in the spreadsheet
Content (required):
I would like to lock down (hard-code / copy-paste) all "HSGETVALUE" formulas, without locking down all the other formulas in the spreadsheet. For instance, I have a spreadsheet with different types of formulas, like basic "SUM" formulas to sum up columns, "DIVISION" formulas to calculate margin percent, etc. Also in the spreadsheet are "HSGETVALUE" formulas. When I sent my spreadsheet to users who don't have access to Oracle, the spreadsheet re-calculates and errors-out, since they can't pull the "HSGETVALUE" formulas. So, I would like to run a process where the "HSGETVALUE" formulas get locked down and