NetworkDays Doesn't work with Excel 2002???

[qlan]

Hi,

I am trying to calculate the NETWORKDAYS and it works fine on my computer, which I have Excel 2000. However, it doesn't work on the other machine that has Excel 2002. What should I do to have this fixed? Thanks so much

 

[Lilliabeth]

Analysis tool-pak add-in

Lilliabeth
-Why use a big word when a diminutive one will do?-

 

[firefytr]

.. found from Tools | Addins. You may need your Office CD also (it's generally handy to keep around) if you did not do a complete install (standard is not complete).

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[qlan]

Yes, on my machine that has Excel 2000, I checked the Analysis ToolPak and Analysis ToolPak - VBA. I do the same thing on the machine that has Excel 2002. However, for some reasons, it works on Excel 2000 but not on Excel 2002. Any ideas. Thanks

 

[AnotherHiggins]

it works on Excel 2000 but not on Excel 2002

My crystal ball is hazy....

What doesn't work? Enabling the Add-Ins, or NetWorkDays?

If you go back to Add-Ins after enabling the Analysis tool-pak, does excel still have a check beside it?

If the Add-In is enabled and the NewWorkDays function still doesn't work, what happens when they try to use it? Does it return an error? If so, what error?

You really need to provide more info if you want help.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[qlan]

I am sorry. Here is what I currently have problem with:

It is excel 2002 and I have Analysis ToolPak Checked. When I open my pricing model, the networkdays formula works just fine.

However, the problem is that this pricing model is used for the online orders. When I go online and try to order and press the button to calculate the price,I got this message saying cannot calculate, please call for the price.

If I go back to the location where this pricing model is located, the networkdays formula is no longer work (#NAME?)eventhough the Analysis ToolPak is still checked. If I unchecked it, press ok and checked back on, the #NAME? then is gone. However, if I try to go online and order and will again have the same problem.

If I don't use networkdays, then it works when I try to order online. I didn't write the web for the online order. Therefore, I don't know if something from the web form has to do with my pricing model

Thanks so much for your time looking into this

 

[firefytr]

How exactly are you accessing the web here? Is this some web-controlled program? Web query? Javascript? Tell us exactly the steps you are taking, exactly what you click.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[qlan]

Hi, it looks like we have problem with our web application that we might need to upgrade to a higher version in order to use NetworkDays. Is there another function I can use beside NetworkDays? Thanks