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.
0 Comments
Leave a Reply. |