| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
static formulas - HELP
All of sudden formulas in ALL my files do not calculate when I change a
number????????? Ideas (solutions) please. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
static formulas - HELP
One likely cause is the calc mode's set to manual.
Click Tools Options Calculation tab. Ensure auto is checked OK. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Henry" wrote: All of sudden formulas in ALL my files do not calculate when I change a number????????? Ideas (solutions) please. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
static formulas - HELP
Your my hero!
(any idea why would it randomly switch to manual?) "Max" wrote: One likely cause is the calc mode's set to manual. Click Tools Options Calculation tab. Ensure auto is checked OK. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Henry" wrote: All of sudden formulas in ALL my files do not calculate when I change a number????????? Ideas (solutions) please. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
static formulas - HELP
(any idea why would it randomly switch to manual?)
Excel sets the session's calc mode based on the mode of the 1st workbook that's opened. If the 1st book's saved mode happen to be manual, then it's manual mode. And any subsequent book(s) that's opened within the same Excel session (irrespective of their earlier saved calc modes) will "take-on" this manual mode, and if saved thereafter would be saved on manual mode. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Henry" wrote in message ... Your my hero! (any idea why would it randomly switch to manual?) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| nyway to copy static valuesAND formulas from one workbook to anothe? | Excel Worksheet Functions | |||
| Static Cell Refrences in Formulas | Excel Discussion (Misc queries) | |||
| keeping formulas static when cutitng and pasting associated celldata | New Users to Excel | |||
| Changing a formulas result to be a static number | Excel Discussion (Misc queries) | |||
| Hyperlinks static but formulas are not. Why? | Excel Discussion (Misc queries) | |||
Hybrid Mode
