Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-21-2020, 12:00 PM
GVaught GVaught is offline Solver Add-in Not Installing Fix Windows 10 Solver Add-in Not Installing Fix Office 2019
Novice
Solver Add-in Not Installing Fix
 
Join Date: Jan 2020
Location: Colorado
Posts: 12
GVaught is on a distinguished road
Smile Solver Add-in Not Installing Fix

Hello Everyone,
I just wanted to pass along an issue that I had for a very long time and no matter how many forums and searches conducted on the subject no suggestions worked for me. However one person mentioned .Net Framework but suggested uninstalling, which I ignored.

I could not load the Solver Excel Add-in using the traditional methods via Excel in both 2016 and 2019. I would always get a message that the file could not be found or Excel would just crash. I even upgraded Windows 7 to Windows 10 hoping it would fix the issue. It did not.

Here is something I tried and it worked.
I just recently installed Office 2019 from Office 2016 and based on the one mention of the .Net framework I decided to open the Solver.XLAM (copy) using Visual Studio 2019. However, I did not get Visual Studio 2019 outright, I got Microsoft VS Version Selector, so I picked that. When a dialog box came up I had a few choices, I picked the one to Trust This Publisher, which is Microsoft, and low and behold Solver loaded to my Data Tab. This was in addition to already having Microsoft as a Trust Publisher in Excel. Now when I open Excel the Solver loads without issue.

So if you hear of someone with this issue, please pass this along. I can only assume if the are using Office 2016 they could try opening an earlier version of Visual Studio. I can only assume Community would do the same. I am an instructor so I have a full blown copy of 2019.
Reply With Quote
Reply

Tags
add-in, excel 2019, solver

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Solver Add-in Not Installing Fix Excel Solver Normie Excel 1 11-19-2015 09:57 AM
Solver Add-in Not Installing Fix How to set this out in Excel or solver brisbaneguy4109 Excel 3 10-18-2015 11:12 PM
Help with Solver Problem myusername343 Excel 0 04-10-2014 10:09 AM
Question on using solver jcg Excel 0 12-13-2011 05:54 PM
Ms word solver DAREGOT Word 1 03-11-2010 11:52 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft