Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formulas not calculating properly
I need help! I created a worksheet before with formulas and I protected the
sheet. I made it so that rows can be added and numbers can be inputted and the formulas will still sum the numbers. It worked fine until today. Now, on the status bar, it shows Calculate and it doesn't add any new numbers inputted. I have to unprotect the sheet and F2 the formula and enter to update the sum. Why is this happening? Thanks for any help. |
#2
|
|||
|
|||
Sounds like you are manual calculation mode. could be the result of several
things. Try going to Tools-- Options--Calculation and see if it is set to manual or automatic. Also, look for and circular reference errors at the bottom of your screen. "SueK" wrote: I need help! I created a worksheet before with formulas and I protected the sheet. I made it so that rows can be added and numbers can be inputted and the formulas will still sum the numbers. It worked fine until today. Now, on the status bar, it shows Calculate and it doesn't add any new numbers inputted. I have to unprotect the sheet and F2 the formula and enter to update the sum. Why is this happening? Thanks for any help. |
#3
|
|||
|
|||
Thank you! That's it!
"Jonathan Cooper" wrote: Sounds like you are manual calculation mode. could be the result of several things. Try going to Tools-- Options--Calculation and see if it is set to manual or automatic. Also, look for and circular reference errors at the bottom of your screen. "SueK" wrote: I need help! I created a worksheet before with formulas and I protected the sheet. I made it so that rows can be added and numbers can be inputted and the formulas will still sum the numbers. It worked fine until today. Now, on the status bar, it shows Calculate and it doesn't add any new numbers inputted. I have to unprotect the sheet and F2 the formula and enter to update the sum. Why is this happening? Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
not calculating formulas | Excel Discussion (Misc queries) | |||
Formulas not calculating??? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Formulas not calculating | Excel Worksheet Functions |