![]() |
Why are my formulas not adding up automatically
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??? |
Why are my formulas not adding up automatically
Calculations may be set to Manual. Click Tools-Options-Calculation. Set
Calculation to Automatic. HTH, Paul "Brittany" wrote in message ... 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??? |
All times are GMT +1. The time now is 03:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com