<div>
Yes, create a test user to test with.<br />
What about Excel's add-in management, does it say the add-in is loaded or deactivated?
</div>


Yes, create a test user to test with.
What about Excel's add-in management, does it say the add-in is loaded or deactivated?

<div>
<div class="content wysiwyg-content">
Hey everyone,<br />
<br />
Took a look at the EE forums but can't seem to find a solution.<br />
<br />
I have a user who is unable to load the Solver add-in in Excel. &nbsp;The add-in is selected, but when going to Data &gt;&nbsp;Analyze, the Solver button is not fully there. &nbsp;To be specific, the question-mark/arrow symbol is there, but it doesn't say Solver. &nbsp;When clicking on the button, nothing happens.<br />
<br />
The user is on Windows 10 with Office O365 2016 v.2215. &nbsp;Our company has gpo restrictions on loading add-ins, but I am able to load and use it on mine and a test machine w.o problem.<br />
<br />
He receives a msg about macros not being able to load, as did I, but on the test machines I received a prompt to trust the add-in, whereas he does not.<br />
<br />
I removed and re-added the add-in, ran a repair on Office, upgraded Office to our current version, and replaced the Solver.xlam file on the user machine, no change.<br />
<br />
The one thing I did not try yet is a different Windows profile.<br />
<br />
Thoughts?<br />
<br />
Thanks,
</div>
</div>


Hey everyone,

Took a look at the EE forums but can't seem to find a solution.

I have a user who is unable to load the Solver add-in in Excel.  The add-in is selected, but when going to Data > Analyze, the Solver button is not fully there.  To be specific, the question-mark/arrow symbol is there, but it doesn't say Solver.  When clicking on the button, nothing happens.

The user is on Windows 10 with Office O365 2016 v.2215.  Our company has gpo restrictions on loading add-ins, but I am able to load and use it on mine and a test machine w.o problem.

He receives a msg about macros not being able to load, as did I, but on the test machines I received a prompt to trust the add-in, whereas he does not.

I removed and re-added the add-in, ran a repair on Office, upgraded Office to our current version, and replaced the Solver.xlam file on the user machine, no change.

The one thing I did not try yet is a different Windows profile.

Thoughts?

Thanks,

Can't use Solver add-in in Excel 2016, does not work

Addins

Windows 10 is a personal computer operating system featuring the "universal application architecture" (UAP); apps can be designed to run across multiple devices with nearly identical code, including PCs, tablets, smartphones, embedded systems, Xbox One, Surface Hub and HoloLens. Windows 10 also includes a virtual desktop system, a window and desktop management feature called Task View, the Microsoft Edge web browser, support for fingerprint and face recognition login, voice-based search (Cortana), new security features for enterprise environments, and DirectX 12 and WDDM 2.0 to improve the operating system's graphics capabilities for games.

Windows 10

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.

Windows OS

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.