Function Values Not Refreshing
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
|