answer of formula doesnt change after original value is changed,

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I tried to work in an excel worksheet. I entered a formula on a cell for eg,
A10 with values from other cells, for eg, A1, A2, A3. The answer was correct.
Then i wanted to change the values in cell A1, A2. But the answer is not
changing. When looking at the formula auditing, its stilling showing the link
to A1, A2 and A3. I am confused. Can you please help me.
 
Try Tools / Options / Calculation Tab / Change from Manual to Automatic
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
excel formula 1
Excel Copy COUNTIF while retaining reference 7
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Bizzare problem, need some HELP!! 3
Sum number range ignoring numbers formatted as text 0
Building closed workbook file path within an Index Function 6
Date addition error 1

Back
Top