Setting a permanent formula

Originally Posted by Richard Buttrey

Hi, and welcome to the forum.

A cell can be either locked and protected or not. You seen to be saying that in a single cell you have a formula which includes some variable text and numbers. Whilst you can't protect a cell and also have it editable, what you can do is have the variable text and numbers in other cells which are not locked, and have the formula in a locked cell refer to these variable cells.

I can set the formula in another document and hyperlink it right?