ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   spreadsheet no longer calculates automatically when figures change (https://www.excelbanter.com/excel-discussion-misc-queries/69519-re-spreadsheet-no-longer-calculates-automatically-when-figures-change.html)

pinmaster

spreadsheet no longer calculates automatically when figures change
 
Somehow you turned off "Auto Calc"......go to Tools/Option/Calculation and
make sure "Automatic" is selected.

HTH
JG

"denobs" wrote:

ive entered a formula which adds a column of figures and before whenever i
change theses figures the formula automatically corrects itself with the
changes
but now this no longer happens and after making my changes i need to
re-enter the formula for the correct the balance - can anyone tell me what is
going on?



All times are GMT +1. The time now is 07:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com