wont calculate

J

john mcmichael

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.
 
S

StinkeyPete

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

Tools>Options>Calculation 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.
 
Top