Hello,
I am new here so apologies in advance if this was covered, couldn't find it on a search. I inherited a worksheet that has formula like:
Cell A1 = $8.04 and Cell A2 = A1/12 which gives the value of $0.67. The problem is when the value in A1 is changed the result in A2 does not adjust. This is the problem for all the formulas in the entire workbook. Is the sheet locked or something? Please advise.
Thanks.
-Tom
I am new here so apologies in advance if this was covered, couldn't find it on a search. I inherited a worksheet that has formula like:
Cell A1 = $8.04 and Cell A2 = A1/12 which gives the value of $0.67. The problem is when the value in A1 is changed the result in A2 does not adjust. This is the problem for all the formulas in the entire workbook. Is the sheet locked or something? Please advise.
Thanks.
-Tom