If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula stopped working
I'm having a rather odd problem with my Excel formulas and hope someone can
help me. Within the week, my Excel spreadsheet formulas have simply stopped working. When I input new data into the sheet, the formula will not calculate new totals like it did last week. Nothing about the formula has changed and it is correct. Even if I alter a figure, it will not recalculate it just sits there showing the same figure that it was before. This has affected all my spreadsheets. Has it been caused by an update? If so, how can I rectify it? |
#2
|
|||
|
|||
Formula stopped working
Hi Tony:
Tools Options... Calculation and check automatic -- Gary''s Student - gsnu200842 "Tony" wrote: I'm having a rather odd problem with my Excel formulas and hope someone can help me. Within the week, my Excel spreadsheet formulas have simply stopped working. When I input new data into the sheet, the formula will not calculate new totals like it did last week. Nothing about the formula has changed and it is correct. Even if I alter a figure, it will not recalculate it just sits there showing the same figure that it was before. This has affected all my spreadsheets. Has it been caused by an update? If so, how can I rectify it? |
#3
|
|||
|
|||
Formula stopped working
"Gary''s Student" wrote: Hi Tony: Tools Options... Calculation and check automatic -- Gary''s Student - gsnu200842 Thanks Gary - Worked a treat!! |
Thread Tools | |
Display Modes | |
|
|