I’d want to reference a named cell in a formula, and use its immediate value, that is, the value it stores at the moment where the sheet is saved. The way to achieve that would be to add a “frozen” attribute to the cell, which modifies its behavior: the value it holds is “frozen” into the formula when the document is saved, and later the user must explicitly ask to update the formulas which reference this cell. Another way would be to create a new type of reference.
I need that to create a model with one sheet per month, which uses bus or train prices, mileage allowance, etc. stored in named cells, but keeps the correct values for past months whenever the rates change.
Does this feature exist, or is it possible to develop it?