![]() |
Excel formulas
I have simple functions in my workseet - e.g. summing 3 cells to get a total.
When I change the value of one of the cells, the total does not change. I cannot figure out why. |
Excel formulas
Maybe check to make sure calculation is set to automatic
Tools/Options/Calculation/Automatic. If a workbook is saved w/calc set to manual, Excel's calculation will be set to manual every time you open the workbook. "Sonora" wrote: I have simple functions in my workseet - e.g. summing 3 cells to get a total. When I change the value of one of the cells, the total does not change. I cannot figure out why. |
All times are GMT +1. The time now is 11:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com