Results 1 to 7 of 7
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Add-in Functions Scope! (Excel 2002)

    Hi,
    If I use one of the Analysis Toolpak functions in a W/B and email the W/B to someone that does not have the Analysis Toolpak active, will that function still work when he opens the W/B?
    Tx
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Add-in Functions Scope! (Excel 2002)

    No, the recipient will get a #NAME error as soon as the cells containing Analysis Toolpak functions are recalculated. You might add an instruction in the e-mail or in the workbook itself on how to activate the Analysis Toolpak.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Add-in Functions Scope! (Excel 2002)

    Thanks
    Regards,
    Rudi

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add-in Functions Scope! (Excel 2002)

    There is another caveat: If the recepient has a different language version of Excel, the ATP functions will have to be translated too.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Add-in Functions Scope! (Excel 2002)

    Thanx, thats good to know...but I don't think it will be the case here in SA. 99.9999% english!
    Regards,
    Rudi

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Add-in Functions Scope! (Excel 2002)

    I thought you had 11 official languages? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    (Afrikaans, English, IsiNdebele, IsiXhosa, IsiZulu, Northern Sotho, Sesotho, Setswana, SiSwati, Tshivenda and Xitsonga)

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Add-in Functions Scope! (Excel 2002)

    Thats human languages....our PC's only talk english! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Regards,
    Rudi

Posting Permissions

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