| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with formulas automatically updating
I have the following in a cell. {=SUM(('Evaluation
Form'!F7:F7="Technical")*('Evaluation Form'!K7:K7="Reject"))}. The problem is when I enter information on the Evaluation Form the cell with the above is not being updated automatically. How can I get it to update automatic. Also I was searching on the discussion group when I saw how to put the {} arround the formula but now I don't remember how. I know it was certain keystrokes that put it there. Thanks for any help. Bob |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with formulas automatically updating
1. Tools Options Calculation Automatic
2. Enter the formula with CNTRL-SHFT-ENTER rather than just the ENTER key. -- Gary''s Student - gsnu200901 "Bobbo" wrote: I have the following in a cell. {=SUM(('Evaluation Form'!F7:F7="Technical")*('Evaluation Form'!K7:K7="Reject"))}. The problem is when I enter information on the Evaluation Form the cell with the above is not being updated automatically. How can I get it to update automatic. Also I was searching on the discussion group when I saw how to put the {} arround the formula but now I don't remember how. I know it was certain keystrokes that put it there. Thanks for any help. Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas Aren't Automatically Updating When Cells Change | Excel Discussion (Misc queries) | |||
| Excel 2007 automatically updating formulas/cells | Excel Discussion (Misc queries) | |||
| My formulas are not automatically updating. What's up with this? | Excel Discussion (Misc queries) | |||
| Excel formulas are not automatically updating | Excel Discussion (Misc queries) | |||
| Automatically updating | New Users to Excel | |||
Linear Mode
