C
Charlie
Whenever I refresh data (Data->Refresh Data) the name
range values are reset from, e.g., $A$1:$A$65534 to $A:$A,
and then the array formulas in which the name is used
won't recalc until I manually fix the values.
Any idea how to stop these from changing?
range values are reset from, e.g., $A$1:$A$65534 to $A:$A,
and then the array formulas in which the name is used
won't recalc until I manually fix the values.
Any idea how to stop these from changing?