Are relative named ranges in Excel volatile?

[SimonGandy]

Hi all,
[I've used this forum for some time as a great source of information - so far, everything I've wanted to know has already been asked and answered, but I can't find anything anywhere about this subject...]

In my workbook, I have a number of sheets with identical structure, performing the same calculations for different datasets. For example, my data units (kg, m, s, etc) are always in column F. I therefore thought I would use a relative named range for column F throughout the workbook. With my cursor in row 1, I created a new named range (called 'Unit_rr') and, in the 'Refers to' window, I wrote:
=!$F1

Having done this, any cell formula on any sheet that references 'Unit_rr' picks up the unit for that row, in column F. The idea was that it would be easier to read and audit the formulae, as I wouldn't need to remember column F contained units, as the named range would make that obvious.
My workbook now has 42 sheets and is 1.2MB, which is small, but its calculation speed is now tangible - there is a pause after every cell entry. I know I could turn off or better control when Excel calculates, but my fundamental question is this: Are relative named ranges such as '=!$F1' volatile?

If they are, I will have to rethink whether they are worth using, after all.
Many thanks indeed in advance for your help.
Simon

 

[joeu2004]

Mixed-relative and relative references like $F1 and F1 are not "volatile" in the usual sense.

That is, their presence per se does not cause their formulas and any direct and indirect references to those formulas to be recalculated unnecessarily.

Even if that reference is in a named range "Refers to" field.

But I am testing with Excel 2010, not Office 365.

I would look for whole-column references like A:A instead of $A$2:$A$100000, for example.

And of course, the use of volatile functions like OFFSET and INDIRECT.

 

[SimonGandy]

That is very helpful - thank-you!