ExcelBanter

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

Sonora

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.

JMB

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