ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   calculation errors (https://www.excelbanter.com/excel-worksheet-functions/93157-calculation-errors.html)

GeekMom

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.

pdberger

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.



All times are GMT +1. The time now is 10:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com