# Short answer:
Excel (annoyingly) only changes formulas automatically if you insert a line
that is within the referenced area of the formula. If you insert or delete
outside the range used by the formula, Excel does not update the formula.
# See this link to fix this issue with hyperlinks:
https://techcommunity.microsoft.com/t5/excel/hyperlinks-not-updating-after-inserting-rows/m-p/3037040