Results 1 to 3 of 3
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can't Find 'networkdays' on ATPVBAEN.XLA (XP; SP3)

    ATPVBAEN.XLA is the add-in that makes the Analysis ToolPak add-in functions available in VBA. It is listed as "Analysis ToolPak - VBA". The one for use in worksheet formulas is "Analysis ToolPak". Which of the add-ins have been checked in each of the workbooks?

  2. #2
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't Find 'networkdays' on ATPVBAEN.XLA (XP; SP3)

    Hans,

    Both items in the Add-in are checked.

    One interesting thing ... I took File B and cleared the cells which reference the networkdays function, then copied the formulas in File A to File B and presto <img src=/S/yep.gif border=0 alt=yep width=15 height=15> it worked.

    The issue must be related to when the "Add-In" in File B was checked and formula entered. Similar to the cart before the horse.

    Thanks,
    John

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can't Find 'networkdays' on ATPVBAEN.XLA (XP; SP3)

    I have two workbooks both utilize the networkdays function in a sheet. Both files work just fine for me. File A works just fine for a co-worker but File B has an issue with the "networkdays' function in ATPVBAEN.XLA.

    Both of us have "Analysis TookPak" enabled and have the same version of Excel.

    The error message appearing with the co-worker is as follows:

    Microsoft Office Excel cannot find 'networkdays' on ATPVBAEN.XLA. There are two possible reasons-

    The name you specified may not be defined.
    The name you specified is defined as something other than a rectangular cell reference.
    Check the name and try again.


    Not sure why,
    Regards,
    John

Posting Permissions

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