Activating an Inactive Excel Add-In

Question

Please how do i activate Solver as an add-in on excel. I keep clicking it but when i go back it is unticked and remains on the section for inactive add-ins. I cannot also find it as part of Regedit so cannot do anything from there too.

Would appreciate help as I have exhausted all ideas.

Joyce Oluwakemi Akingbule

Answer 1

Dear Joyce Oluwakemi Akingbule

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

Generally, you can by the following steps to activate the solver add-in:

• Open Excel. go to File > Options
• Click Add-Ins, and then in the Manage box, select Excel Add-ins>click Go
• In the Add-Ins available box, select the Solver Add-in check box, and then click OK.
• After you load the Solver Add-in, the Solver command is available in the Analysis group on the Data tab.

If you can't find teh Solver option in Data tab after you check the box of Solver to enable it, try to use online repair tool to check teh result, for your reference: Repair an Office application (microsoft.com)

Make sure your Excel have updated to the latest version, sometimes, the update will also affect the use of office app, for teh update version, refer to Update history for Microsoft 365 Apps (listed by date) - Office release notes | Microsoft Docs

Besides, we need more detailed information about the situation you are experiencing so that we can have a further investigation:

• Can you tell us your Excel product information? Go to File>Account then gives us a screenshot.
• Give us a screenshot that remains on the section for inactive add-ins

We’re looking forward to your reply and we’ll continue to help you all the time! If there have any unclear or misunderstanding, you can post back anytime.

Thank you for your understanding and cooperation in Microsoft Community.

Sincerely,

Stacey | Microsoft Community Moderator

***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***

Answer 2

Thanks Stacey,

Please see the screenshots below. I have attempted the repair option too and also the uninstalling option but still no luck:

Regards,

Joyce Oluwakemi Akingbule