question

MohamedSAKHO-5585 avatar image
0 Votes"
MohamedSAKHO-5585 asked MohamedSAKHO-5585 answered

How to load excel addin at the startup for all profiles

Hello All,

I have an application which run with an excel addin.
I would like that when I launch excel, that addin loads at startup of excel for all users profiles.
Please does someone can help me for my request?
By advance thank you

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered

Hi @MohamedSAKHO-5585

I would like that when I launch excel, that addin loads at startup of excel for all users profiles.

Could you please explain more about "all users profiles"?
Does it mean the users who sign into Office or Windows account users?

Generally, for Excel COM add-ins, we need to added addins folder to trusted location via clicking Options > Trust Center > Trust Center Settings > Trusted Locations, add the folder path where the addin is located.

Then we can go to Registry Editor, try to navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins, find the addin and change its value of LoadBehavior to 3, it means the addin loaded at startup.
(Serious problems might occur if you modify the registry incorrectly. Before you modify it, please remember to back up the registry for restoration in case problems occur.)
For more information, please refer to "Excel COM add-ins and Automation add-ins".

Any misunderstandings, welcome to post back.


If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MohamedSAKHO-5585 avatar image
0 Votes"
MohamedSAKHO-5585 answered

Hello @emilyhua-msft,

Thank you for your answer. For "all users profiles", I want to say windows account users.
I would like when any user logon to the server, when the user launch excel, the addin loads automatically.
I already navigate to "HKEY_USER.Default\Software\Microsoft\Office\Excel\Addins" and create the key, and the path of the dll, but it not works.
I also copied the dll to "C:\Program Files (x86)\Microsoft Office\Office16\XLSTART" but it not works.197374-2022-04-27-17-56-07-window.png197406-2022-04-28-15-01-47.png



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.