Question : excel formula update insert row column
Answered by : charlesalexandre-roy
# 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/3037040Source : https://answers.microsoft.com/en-us/msoffice/forum/all/formula-not-updating-when-adding-a-new-row/7ddb0b46-475a-41fa-af9f-3542ce7fef05?auth=1 | Last Update : Thu, 19 May 22