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?