Home |
Search |
Today's Posts |
#1
|
|||
|
|||
#num! error message
have a huge complex workbook. Several of the cells contain the error #num!.
If I click on a cell with the error message, press F2 key then enter, the error message goes away. any suggestions why? |
#2
|
|||
|
|||
it varies. It could be =a3-a1 or =sum(l23:l34) or =l35/l57*1000 The most
complex was a =ROUND "Frank Kabel" wrote: Hi what formula is in these cells? "Brenda" wrote: have a huge complex workbook. Several of the cells contain the error #num!. If I click on a cell with the error message, press F2 key then enter, the error message goes away. any suggestions why? |
#3
|
|||
|
|||
Hi
an you don't have this error in the referenced cells? -- Regards Frank Kabel Frankfurt, Germany "Brenda" schrieb im Newsbeitrag ... it varies. It could be =a3-a1 or =sum(l23:l34) or =l35/l57*1000 The most complex was a =ROUND "Frank Kabel" wrote: Hi what formula is in these cells? "Brenda" wrote: have a huge complex workbook. Several of the cells contain the error #num!. If I click on a cell with the error message, press F2 key then enter, the error message goes away. any suggestions why? |
#4
|
|||
|
|||
It is very strange. It opened on another PC, it is fine. On hers, we had
several of these messages. If I would click on the cell with the error and press F2 enter, the error message would go away. Some of the cells that had the message were referring to cells with the message. So, I would click F2 enter on them, go to the next cell with an error and do the same. Very strange. What does F2 enter do? It's almost like it is not calculating completely. "Frank Kabel" wrote: Hi an you don't have this error in the referenced cells? -- Regards Frank Kabel Frankfurt, Germany "Brenda" schrieb im Newsbeitrag ... it varies. It could be =a3-a1 or =sum(l23:l34) or =l35/l57*1000 The most complex was a =ROUND "Frank Kabel" wrote: Hi what formula is in these cells? "Brenda" wrote: have a huge complex workbook. Several of the cells contain the error #num!. If I click on a cell with the error message, press F2 key then enter, the error message goes away. any suggestions why? |
#5
|
|||
|
|||
F2 tells excel you want to edit the cell. Hitting enter says you're finished
with the editing. So excel sees it as a change and reevaluates the formula. Maybe select the whole sheet edit|replace what: = (equal sign) with: = (equal sign) replace all would wake excel up for all your formulas. Brenda wrote: It is very strange. It opened on another PC, it is fine. On hers, we had several of these messages. If I would click on the cell with the error and press F2 enter, the error message would go away. Some of the cells that had the message were referring to cells with the message. So, I would click F2 enter on them, go to the next cell with an error and do the same. Very strange. What does F2 enter do? It's almost like it is not calculating completely. "Frank Kabel" wrote: Hi an you don't have this error in the referenced cells? -- Regards Frank Kabel Frankfurt, Germany "Brenda" schrieb im Newsbeitrag ... it varies. It could be =a3-a1 or =sum(l23:l34) or =l35/l57*1000 The most complex was a =ROUND "Frank Kabel" wrote: Hi what formula is in these cells? "Brenda" wrote: have a huge complex workbook. Several of the cells contain the error #num!. If I click on a cell with the error message, press F2 key then enter, the error message goes away. any suggestions why? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|