ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   wont calculate (https://www.excelbanter.com/excel-discussion-misc-queries/40137-wont-calculate.html)

john mcmichael

wont calculate
 
i have a spreadsheet that allows me to enter information and formulas but it
will not calculate. Is there are setting that may need to be changed?

Thanks for the help.

StinkeyPete

HIt F9 to see it it calculates, if it does then go to:

ToolsOptionsCalculation tab
see if the maunal option is selected and change it to automatic.

If it doesn't you may wants to also make sure that your spreadsheet does not
have any circular refrences.


"john mcmichael" wrote:

i have a spreadsheet that allows me to enter information and formulas but it
will not calculate. Is there are setting that may need to be changed?

Thanks for the help.



All times are GMT +1. The time now is 02:19 AM.

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