Are you talking about a function or a formula? If it is user-defined
function, try adding Application.Volatile to the beginning of the code.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Carlee" wrote in message
...
Hi there,

I have a complex function that sums or averages a series a values, based
on
month. Occasionally, when i open the workbook and specifically, the
sheet,
the function shows as '0' or 'NA' even though there are values that meet
the
date criteria. If i go into the function and click in it, then press
enter,
the value appears.

Now, i could do this for all 200 functions, on three sheets, but that
won't
work. What can i do to make this stop. I have checked Tools Options
Calculations and it is set to automatic.

Ideas?
--
Carlee