Results 1 to 5 of 5

Thread: How to modify the load behaviour of Excel 2010 add-in (e.g. flexfind)
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2018
    Posts
    22
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default How to modify the load behaviour of Excel 2010 add-in (e.g. flexfind)

    I'm using Microsoft Excel 2010 and had a few useful add-ins like flex find installed.
    https://www.jkp-ads.com/officemarket...en.asp.However, I do not use these add-ins frequently.
    Since it seems that Microsoft excel 2010 loads, these add-ins at start-up and it significantly increases the delay in starting up, I was hoping to make these load only when I need them.

    The documentation in Microsoft at https://support.microsoft.com/en-in/...mation-add-ins says that the load behaviour can be modified by going into the registry.


    However, when I go into the same path in the registry, I do not find any mention of these add-ins. Also, another issue is that whenever I wanted to use these add-ins, I had to specifically go and load them manually myself. At the same time, during starting up, I clearly see a message in the splash window stating that these add-ins are being loaded.


    So how do I avoid add-ins being loaded at start-up.. (And at the same time, as I stated, it seems that add-ins are really not being loaded because I have to manually load them when I need to use)


    Thank you for any inputs

  2. #2
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,867
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    7 Thread(s)

    Default Re: How to modify the load behaviour of Excel 2010 add-in (e.g. flexfind)

    This works for me

    At end of day or when you no longer need to use ...
    To Unload AddIn
    Code:
    AddIns("Name of AddIn").Installed = False
    To Load AddIn when required
    Code:
    AddIns("Name of AddIn").Installed = True
    Last edited by Yongle; Mar 25th, 2019 at 11:36 AM.

  3. #3
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,803
    Post Thanks / Like
    Mentioned
    48 Post(s)
    Tagged
    6 Thread(s)

    Default Re: How to modify the load behaviour of Excel 2010 add-in (e.g. flexfind)

    Flex find is not a COM add-in so you don't need the registry, you can just use the Add-ins dialog to load/unload them.

  4. #4
    New Member
    Join Date
    Sep 2018
    Posts
    22
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to modify the load behaviour of Excel 2010 add-in (e.g. flexfind)

    Thank you for your responses.

    @RoryA, Thank you for explaining the difference between the C OM and other add-ins. I used to wonder why am not able to start using Flex find immediately after starting Microsoft Excel 2010. Now I understand.


    However, now the problem that I see is that even though the add-ins are actually not being loaded, I see them being mentioned in the splash screen of Microsoft Excel. When it is starting up stating that these add-ins are being loaded. And it spends quite a bit of time on loading these add-ins. It is almost 2 minutes that it takes to load the add-ins that are actually not COM.


    Is this expected behaviour or is there anything that I can do to prevent the loading of add-ins on starting up of Microsoft Excel?


    Thank you for any inputs

  5. #5
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,803
    Post Thanks / Like
    Mentioned
    48 Post(s)
    Tagged
    6 Thread(s)

    Default Re: How to modify the load behaviour of Excel 2010 add-in (e.g. flexfind)

    You just use the add-ins dialog, as I mentioned, to disable or enable regular add-ins.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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