If you cannot find the Solver add-in in the list of available add-ins, you may need to search for it on your machine. Check Solver Add-in and click OK to re-enable the add-in.Note: If you don’t see the Developer Ribbon, you’ll need to enable it. In the Ribbon, select Developer > Add-ins > Excel Add-ins. Then, under Manage, make sure Excel Add-ins is selected, and then click Go… In the Ribbon, select File > Options and then select Add-ins.If you encounter an error at this point, you can try re-enabling the add-in. Then, select ActiveX Settings and in ActiveX Settings for all Office Applications make sure Enable all controls without restrictions and without prompting (not recommended, potentially dangerous controls can run) is selected.In the Ribbon, select File > Options and then (1) select Trust Center and (2) Trust Center Settings.This could be due to the fact your ActiveX settings are disabled and for Solver to work, they need to be enabled. Once you have enabled Solver and try to use it, you may encounter the following error. This tutorial discusses a few reasons why this may occur and how to fix the problem of Solver not working.

On occasion, once the add-in has been enabled, it does not work. Solver is an add-in that is provided with Excel and is used to perform “what-if” analysis by providing alternative answers to a formula in a cell based on values you may pass to the formula from other cells in your workbook. This tutorial demonstrates how to fix the error when Solver is not loading in Excel.

Solver add in excel mac