Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas stop working on all excell spreads at the same time
The concern is did swomething get turned off in excel or is this the work of a virus? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas stop working on all excell spreads at the same time
i suggest you look at your TOOLS / OPTIONS and chose the CALCULATIONS tab,
you may find that you have the 'manual' option checked. Change to AUTOMATIC - then close excel and reopen all your documents. You may need to do this for each doc, but sometimes Excel has a 'funny five mins' |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas stop working on all excell spreads at the same time
Hi
The Automatic/Manual setting of calculation is Excel-wide. This means that it's either on for all, or off for all. Whether it is on or off is determined by its setting in the first workbook you open in the session. Andy. "BuffySlay" wrote in message ... i suggest you look at your TOOLS / OPTIONS and chose the CALCULATIONS tab, you may find that you have the 'manual' option checked. Change to AUTOMATIC - then close excel and reopen all your documents. You may need to do this for each doc, but sometimes Excel has a 'funny five mins' |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas stop working on all excell spreads at the same time
And... it will take on the setting of the most recent file you open... much
to my annoyance when all of a sudden auto-calc gets turned off... <Andy wrote in message ... Hi The Automatic/Manual setting of calculation is Excel-wide. This means that it's either on for all, or off for all. Whether it is on or off is determined by its setting in the first workbook you open in the session. Andy. "BuffySlay" wrote in message ... i suggest you look at your TOOLS / OPTIONS and chose the CALCULATIONS tab, you may find that you have the 'manual' option checked. Change to AUTOMATIC - then close excel and reopen all your documents. You may need to do this for each doc, but sometimes Excel has a 'funny five mins' |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas for employee time sheets | Excel Worksheet Functions | |||
How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
Can't stop time duration [hh]:mm:ss converting to time of day | Excel Discussion (Misc queries) | |||
Formula's not working | Excel Discussion (Misc queries) | |||
Formulas stop calculating at random times when editing a few spreadsheets. | Excel Discussion (Misc queries) |