Without deleting or adding rows or columns, column references in formulas change from $A:$A to $A$1:$A$983040, leading to #REF errors. I haven't deleted or added rows or columns, but have edited data in these rows or columns.
Hello, Thank you for reporting the bug. This issue has previously been reported, so this bug will be resolved as a duplicate of the earlier report. You will automatically be added to the CC list of the other bug. *** This bug has been marked as a duplicate of bug 48571 ***