| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula Issues
Recently, formulas in my excel spreadsheets fail to update unless I click on
the formula bar, and then click enter. For example, if I have a formula in a cell that is supposed to calculate the product of values contained in two other cells, I can change one of the the values in the other cells and the result of the formula that calulates the product will not change. If I click in the formula bar and hit enter then the product will change. -- TS |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formula Issues
Tools Options... Calculate check automatic
-- Gary''s Student - gsnu200799 "TS" wrote: Recently, formulas in my excel spreadsheets fail to update unless I click on the formula bar, and then click enter. For example, if I have a formula in a cell that is supposed to calculate the product of values contained in two other cells, I can change one of the the values in the other cells and the result of the formula that calulates the product will not change. If I click in the formula bar and hit enter then the product will change. -- TS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula issues | Excel Worksheet Functions | |||
| Excel 2003 formula issues | Excel Worksheet Functions | |||
| Issues with my excel formula as it needs Circular reference - hlp | Excel Worksheet Functions | |||
| Issues with formula not duplicating | Excel Worksheet Functions | |||
| Excel formula issues, wierd.. | Excel Discussion (Misc queries) | |||
Linear Mode
