| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Has anyone had formulas change automatically with no explanation? | Excel Worksheet Functions | |||
| Accounting format now no longer display negative figures in ( )'s | Excel Discussion (Misc queries) | |||
| automatically change text case on entry | Excel Discussion (Misc queries) | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
| how do you change pathways (links) when consolidating spreadsheet. | Excel Discussion (Misc queries) | |||
Threaded Mode
