Hello. I am trying to modify someone else's file, and I am encountering an unusual problem. Let me explain with an example.
Let's say there is a "Total" tab with formulas in line 10, columns A to F, that adds up all of the corresponding values in line 10, columns A to F, on tabs X, Y, and Z. All four tabs reside in the same file.
Next, I select all four tabs, and then MOVED the entire line 10 to line 5. At this point, shouldn't all the formulas on the Total tab now point to line 5 on tabs X, Y, and Z? Instead, on this particular file, the formulas still point to line 10.
Does anyone have any idea as to what can be causing this? I performed several tests on a new file and it seems like this should not be happening.
Thanks for your help!
Let's say there is a "Total" tab with formulas in line 10, columns A to F, that adds up all of the corresponding values in line 10, columns A to F, on tabs X, Y, and Z. All four tabs reside in the same file.
Next, I select all four tabs, and then MOVED the entire line 10 to line 5. At this point, shouldn't all the formulas on the Total tab now point to line 5 on tabs X, Y, and Z? Instead, on this particular file, the formulas still point to line 10.
Does anyone have any idea as to what can be causing this? I performed several tests on a new file and it seems like this should not be happening.
Thanks for your help!