Function dosn't work in Excel 2007 but did in 2003
 

I have a worksheet which was created in Excel 2003. after upgrading to 2007
it containes a function =number.workingdays(A1;A2) which dosn't work. If I
open the worksheet in 2007, and dobbelt click on the function then it works.

Is there something I have to change in the settings, so the function works
automatically?

Function dosn't work in Excel 2007 but did in 2003
 

That doesn't look like the name of a function in my USA version of xl2003.

But it could be a difference in installed versions (language) or it could mean
that you're using an addin that isn't available in xl2007.

It may help if you include the language of excel for both your xl2003 and xl2007
versions.

In xl2003 (USA version), there's an =networkdays() function and an =workday()
function. Both of these are part of the analysis toolpak in xl2003, but they're
built into xl2007 proper.



Harding wrote:

I have a worksheet which was created in Excel 2003. after upgrading to 2007
it containes a function =number.workingdays(A1;A2) which dosn't work. If I
open the worksheet in 2007, and dobbelt click on the function then it works.

Is there something I have to change in the settings, so the function works
automatically?

--

Dave Peterson