Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formuls not working (Excel 2007)
Hello all,
I'm having a problem with a spread sheet that was created in Excel 2000. My formulas are no longer working. They are not calculating. Option to have formulas €śWorkbook Calculation€ť is set to €śAutomatic€ť. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formuls not working (Excel 2007)
Hi,
A few questions - 1. Are All formulas not working or just some of them? 2. Does pressing F9 work 3. test - enter three numbers in a range and sum them - did the formula caluculate correctly? 4. change one of the three numbers in the range - does the formula update? 5. do the formulas still work in 2000? Cheers, Shane Devenshire "pgarcia" wrote: Hello all, I'm having a problem with a spread sheet that was created in Excel 2000. My formulas are no longer working. They are not calculating. Option to have formulas €śWorkbook Calculation€ť is set to €śAutomatic€ť. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formuls not working (Excel 2007)
Sorry, I was held up on something.
Ok, it seem it's just the SUMPRODUCT function that is not working. I have SUMPRODUCT in some other workbook and they do not work ether. F9 does not do anything. To get it to work, I have to be in that cell and click F2. Strange. Any ideas? =SUMPRODUCT(--(H18:H1002),--(H18:H100<7)) "Shane Devenshire" wrote: Hi, A few questions - 1. Are All formulas not working or just some of them? 2. Does pressing F9 work 3. test - enter three numbers in a range and sum them - did the formula caluculate correctly? 4. change one of the three numbers in the range - does the formula update? 5. do the formulas still work in 2000? Cheers, Shane Devenshire "pgarcia" wrote: Hello all, I'm having a problem with a spread sheet that was created in Excel 2000. My formulas are no longer working. They are not calculating. Option to have formulas €śWorkbook Calculation€ť is set to €śAutomatic€ť. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
F2 Key not working in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 - sum function not working | Excel Worksheet Functions | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
Excel 2007 links not working | Excel Discussion (Misc queries) | |||
how do I do a formuls in excel such as (if a1=somthing then b1=a . | Excel Worksheet Functions |