Problem formulas.xlsx
Ok here is my problem. I have a large workbook with hundreds of formulas and I have been using these formulas for quite some time. When I insert a row or columb, the formulas do not adjust the original cells they were written for. If you click on the cell to view the formula the formula is correct but the answer still uses the original cells. If you double click the cell to show the formula boxes the boxes are not where the formula says they are. I have tried putting calculation to automatic, doing it manually(F9) but none of these things work. To better illustrate what I am saying: In C1 I will have a formula that adds A1 and B1. Say the values are 10 and 20 so the answer is 30. If I insert two rows the formula in C3 now says A3+B3 but the values in A3 and B3 are say 5 and 10 so the answer is now supposed to be 15 but it stays 30. Even if I delete the number in A1 and B1 the answer remains 30. There are no $ signs in my formula. Help please!
Bookmarks