Hi,

Just wondering if it is possible to have a formula in a cell but over write it with other digits while preserving the underlying formula?

I can lock the sheet/workbook but cant edit the cells once this is done?

I'm hoping to be able to delete what ever I have overwritten and for the formula to then take effect again.

Thanking you in advance