Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
How to lock down HSGETVALUE — Cloud Customer Connect
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

Question
2
Views
0
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!