Problem with excel formulas

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
 
G

Guest

Check under the menu Tools/Option/Calculation on the
toolbar and make sure the Automatic readio button is
selected.
 
M

Max

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top