statements not functioning on other LAN computers

[drewmacher]

Hello. I used an Excel spreadsheet, and I tried running it unde
another computer in a LAN environment, and some of the statements i
Excel using networkday didn't function, it displayed #NAME?..doe
anyone know how to correct this please

 

[Mike]

Hello. I used an Excel spreadsheet, and I tried running it under
another computer in a LAN environment, and some of the statements in
Excel using networkday didn't function, it displayed #NAME?..does
anyone know how to correct this please?

The NETWORKDAYS function is part of the Analysis Tool Pak. You will
need to make sure that the Analysis Tool Pak is loaded on each machine
that will use this file. Go to Tools - Add Ins on the menu, it should
be near the top of the list.


Hope this helps,

Mike