On Wed, 5 Jan 2005 16:59:08 +0530, "Sharad Naik"
wrote:

Well "NetWorkDays" is not a excel built-in function so seems
to be your user-defined function.
So where is the function NetWorkDays() located? in an add-in ?
or in the workbook you open?

Where - ever the code for the fuction is located , add line
Application.Volatile at the top in the function code.

Sharad

The NetWorkDays function is in the Excel Analysis Tool Pack which is
installed on the machines where this application runs.

I've tried Application.Volatile as you suggest and it still doesn't
work.

Nirmal