L
learningaccess
Hi -
I have a massive spreadsheet with formulas in it and variable input data. I
don't want to protect the whole worksheet because there is variable data that
effects formula output.
I wondered.... is there a way to protect my formulas only so that I don't
fat finger and ruin a formula (that has taken time and consideration) and
that I can only change the variable data input?
For example, if I have a formula such that if Q1 actual sales are greater
than or equal to 110% of Q1 Plan then the customer gets a reward of 5% of Q1
actual sales. So I don't want to ever change the formula, but I might want
to change Q1 actual data if it changes due to adujustments or incorrect input
on my part.
I tried copy, paste special, formulas, but that did not freeze the formula
cell.
Please let me know.
Thank you very much.
I have a massive spreadsheet with formulas in it and variable input data. I
don't want to protect the whole worksheet because there is variable data that
effects formula output.
I wondered.... is there a way to protect my formulas only so that I don't
fat finger and ruin a formula (that has taken time and consideration) and
that I can only change the variable data input?
For example, if I have a formula such that if Q1 actual sales are greater
than or equal to 110% of Q1 Plan then the customer gets a reward of 5% of Q1
actual sales. So I don't want to ever change the formula, but I might want
to change Q1 actual data if it changes due to adujustments or incorrect input
on my part.
I tried copy, paste special, formulas, but that did not freeze the formula
cell.
Please let me know.
Thank you very much.