| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas will not compute
I have a worksheet with some simple formulas, 1 for aging and another to
compute a cell * a fixed number. one is today()-H1, the other is G4*78. The formula works fine for existing data that is in the spreadsheet. Now for some reason, when i open the spreadsheet and enter in a value in G4, the cell the formula is in does not change anymore, it just stays the same. When i copy the formula and paste it into another cell, the formula reference updates correctly, but when i put data in the cell the formula refers to, it does not update the value in the cell. any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formulas will not compute
Tools|Options|Calculation tab, check Automatic
-- Kind regards, Niek Otten Microsoft MVP - Excel "phil" wrote in message ... |I have a worksheet with some simple formulas, 1 for aging and another to | compute a cell * a fixed number. one is today()-H1, the other is G4*78. The | formula works fine for existing data that is in the spreadsheet. Now for | some reason, when i open the spreadsheet and enter in a value in G4, the cell | the formula is in does not change anymore, it just stays the same. When i | copy the formula and paste it into another cell, the formula reference | updates correctly, but when i put data in the cell the formula refers to, it | does not update the value in the cell. any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formulas will not compute
That was it - glad it was so simple. Thank you very much!
"Niek Otten" wrote: Tools|Options|Calculation tab, check Automatic -- Kind regards, Niek Otten Microsoft MVP - Excel "phil" wrote in message ... |I have a worksheet with some simple formulas, 1 for aging and another to | compute a cell * a fixed number. one is today()-H1, the other is G4*78. The | formula works fine for existing data that is in the spreadsheet. Now for | some reason, when i open the spreadsheet and enter in a value in G4, the cell | the formula is in does not change anymore, it just stays the same. When i | copy the formula and paste it into another cell, the formula reference | updates correctly, but when i put data in the cell the formula refers to, it | does not update the value in the cell. any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XLS Formulas work only in new documents, not in "open"ed ones !!?? | Excel Discussion (Misc queries) | |||
| How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
| How to change column letters to correct ones in many formulas automatically? | Excel Worksheet Functions | |||
| how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Hybrid Mode
