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

6 Replies

  • 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

Resources