Why are my formulas not adding up automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on an excell spreadsheet for my boss its a timesheet for payroll
and it says my formulas are all correct but when i enter the hours the
formulas dont automatically work until i click on the cell that contains the
formula and click enter then it works fine does anyone know why this is
happening and how i can change it???
 
Calculations may be set to Manual. Click Tools-Options-Calculation. Set
Calculation to Automatic.

HTH,
Paul
 
You must log in or register to reply here.

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

Similar Threads

Adding Hours Worked Correctly 3
Yet another question about my timesheet 3
Why won't target cell data changes trigger formula evaluation? 3
error with countif formula on when adding linked spreadsheets 0
Excel Time Rounding in Excel 2
Nesting named formulas 2
Bonus/Absence/Timesheet workbook help needed. 6
Get "####" when use alpha char in a cell referenced by a formula 5

Back
Top