Problem with excel formulas

  • Thread starter Thread starter Max
  • Start date Start date
M

Max

I've made this spreadsheet to calculate workers salary in
wich you enter the number of hours worked and then it
calculates the final payment.

The problem is that suddenly, after I change the number
of hours, for example from 70 to 80, the cells won't
update its content. I used to thought that it was a lack
of RAM problem, but now I'm on a P4 2.6c with 512MB DDR,
so it can't be.

Now the cells only update after I press f2 and hit enter.

On new workbooks everything seems to work fine.

Any solutions? (Other than making the spreadsheet again
on a new file) Thanks
 
Check under the menu Tools/Option/Calculation on the
toolbar and make sure the Automatic readio button is
selected.
 
Thanks. That was it.
-----Original Message-----
Check under the menu Tools/Option/Calculation on the
toolbar and make sure the Automatic readio button is
selected.
.
 
Back
Top