ExcelBanter - How do I make a formula automatically detect changes in values

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I make a formula automatically detect changes in values (https://www.excelbanter.com/excel-worksheet-functions/136918-how-do-i-make-formula-automatically-detect-changes-values.html)

LMoore

How do I make a formula automatically detect changes in values

How do I make formulas (such as summations) automatically detect when I can a
value in one or more of the cell that are included in the formula without
double clicking cell everytime I make a change?

John

How do I make a formula automatically detect changes in values

Check toolsoptionscalculation tab and make sure it is set to automatic
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

"LMoore" wrote:

How do I make formulas (such as summations) automatically detect when I can a
value in one or more of the cell that are included in the formula without
double clicking cell everytime I make a change?

All times are GMT +1. The time now is 09:25 AM.