You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to lock down HSGETVALUE

Received Response
22
Views
1
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!