Forum Discussion

tanjulian90's avatar
tanjulian90
Copper Contributor
Feb 04, 2020

EXCEL SOLVER ADD IN PROBLEM

Hi guys! I would really love to have some fix for my problem. So, I've been trying to put the solver add in for my excel but there's always a prompt whenever I close my excel (photo attached below)  ...
excel
JKPieterse's avatar
JKPieterse
Silver Contributor
Feb 04, 2020
That should not be happening. I suggest to try running a repair using Office setup.
tanjulian90's avatar
tanjulian90
Copper Contributor
Feb 05, 2020
I tried that but the problem still continues to exist
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Feb 05, 2020
    Try this:
    Open Excel > File > Options > Trust Center > Trust Center Settings. On these tabs:

    > Trusted Locations > Uncheck "Disable all trusted locations"
    > Active X Settings > Select "Prompt me before enabling all controls with minimal restrictions"
    > Addins > No boxes checked
    > Macro settings > Disable All macros with notification
    • tanjulian90's avatar
      tanjulian90
      Copper Contributor
      Feb 05, 2020

      Well those are the settings that are already in my excel before hand 😕

      • dpic44's avatar
        dpic44
        Copper Contributor
        Feb 24, 2020

        tanjulian90 I'm having the same issue.  What version of Office are you using and is it 64 bit or 32 bit?

         

Resources