statements not functioning on other LAN computers

  • Thread starter Thread starter drewmacher
  • Start date Start date
D

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
 
drewmacher > said:
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?
Click to expand...


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
 
Back
Top