Office 2002, SP2
AutoCalculate Mode

I have created a UDF (User Defined Function) within the workbook as a
separate module for the file that I plan on using the function. As data is
modified in the workbook, all calculations are taken place EXCEPT for those
cells that involves the UDF, which throws the results off throughout the
workbook.

Is there a way to force these UDFs to run at the required times?

The only thing I been able to do to get around the issue is to have the
cells editted in some form or manner, which since the UDF that I created is
for a calculated column of a table, I have to select the range below the
header row, then do a Fill down (Ctrl-D) to force them to calculate.

--
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000