By default, Excel will recalculate its functions every time a cell value changes.
Usually when you create a name for a range, you will directly use the cell reference. Otherwise the blank items will also appear in the reference range.
Most of the time, you will search on the Internet for some advice.
However, data recovery is not as easy as you may think.
The defined named can help you increase your work pace.
However, the reference range in the name will not update automatically.