| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel sometimes not Calculating???
Excel2003 ...
Is there a reason why certain Formulas in a spread sheet would just quite working? Formulas have worked fine for sometime & now they do not calculate. Note: This has only started recently & on more than 1 spread sheet ... Some Cols calculate & others do not ... :( Any hints? ... Thanks ... Kha |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel sometimes not Calculating???
Rule out the usual culprit, calc mode set to Manual
Click Tools Options Calculation tab Check Automatic OK -- Max Singapore http://savefile.com/projects/236895 Downloads:20,000 Files:362 Subscribers:62 xdemechanik --- "Ken" wrote: Excel2003 ... Is there a reason why certain Formulas in a spread sheet would just quite working? Formulas have worked fine for sometime & now they do not calculate. Note: This has only started recently & on more than 1 spread sheet ... Some Cols calculate & others do not ... :( Any hints? ... Thanks ... Kha |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel sometimes not Calculating???
Max ... (Good morning)
The "culprit" was me ... Formulas were working fine ... Section of ws I was looking @ appeared blank ... However, Formula was returning a null ("") for this particular section of the ws ... If I had just scrolled down (which eventually I did) I would have seen Formulas working as intended ... :( Just another fine example of "dead line" brain cramps ... Thanks for supporting these boards ... Kha "Max" wrote: Rule out the usual culprit, calc mode set to Manual Click Tools Options Calculation tab Check Automatic OK -- Max Singapore http://savefile.com/projects/236895 Downloads:20,000 Files:362 Subscribers:62 xdemechanik --- "Ken" wrote: Excel2003 ... Is there a reason why certain Formulas in a spread sheet would just quite working? Formulas have worked fine for sometime & now they do not calculate. Note: This has only started recently & on more than 1 spread sheet ... Some Cols calculate & others do not ... :( Any hints? ... Thanks ... Kha |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating In Excel | Excel Discussion (Misc queries) | |||
| Calculating In Excel | Excel Discussion (Misc queries) | |||
| calculating age in excel | New Users to Excel | |||
| In excel the sum is not calculating | Excel Worksheet Functions | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Hybrid Mode
