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.
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.
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.
"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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks