My cell formula results won't update automatically. Help?

T

Tori

I have a cell formula that references other cells in the row. If I change the
value in one of the other cells, the result of my formula does not update
unless I click in the formula bar. Is there a setting that updates results
automatically?
 
S

Sean Timmons

Tools - Options - Calculation tab. Ensure you have calculations set to
Automatic.
 

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 VBA 1
Excel Formula Issues 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Displaying results in formula bar when cell is hidden 1
Excel Formula 1
Why doesn't excel count function update automatically? 1
Formula copying error 3
How To Have A Cell Be Blank If... 2

Top