Results 1 to 3 of 3

Thread: #NAME error

  1. #1
    3 Star Lounger
    Join Date
    May 2001
    Location
    Berkeley, California, USA
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    #NAME error

    I have created a formula to calculate processing time as follows:
    =NETWORKDAYS(E18,H18,$O$16:$O$25)
    E contains the date in
    H contains the date out
    O16:025 contain our hollidays
    It works perfectly on my computer but returns a #NAME error on my co-workers computers.
    I distributed the spread sheet by Email as a protected spread sheet.
    Can anyone tell me what is wrong? <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: #NAME error

    #NAME error is a sign that the function is not available to the system. Provided your co-worker has the Analysis Toolpak installed as part of Excel, then you should be able to activate it by going to Tools, Add-ins and ensuring the the check box beside it toolpak is ticked.

    NETWORKDAYS requires that the Analysis Toolpak be installed and active. If you cannot find a reference to it by the the above procedure, you will need an Office Installation CD and install it from there.

    Hope that helps you out.

  3. #3
    3 Star Lounger
    Join Date
    May 2001
    Location
    Berkeley, California, USA
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: #NAME error

    Thank you. That was the problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •