Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation errors
I have been learning to use new functions in Excel and have hit a problem
with one variable tables. I was able to do a simple table yesterday but since adding solver to Excel my table does not calculate it just repeats the original formula solution. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation errors
Geek --
If I understand you, when you add change data in your worksheet, formulas are no longer calculating automatically. If that's the problem (and you can test it by pressing F9), then go to ToolsOptionsCalculation and make sure it's clicked to calculate manually. HTH "GeekMom" wrote: I have been learning to use new functions in Excel and have hit a problem with one variable tables. I was able to do a simple table yesterday but since adding solver to Excel my table does not calculate it just repeats the original formula solution. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignore errors when calculation average of multiple ranges | Excel Worksheet Functions | |||
Why do I get calculation errors with Athlon and Excel 2003? | Excel Discussion (Misc queries) | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions |