/
Confirm if Excel Solver is Working

Confirm if Excel Solver is Working

Check for Excel issues by verifying if Solver is working


A quick and easy way to confirm if Excel has become corrupted is by checking if the Solver module is working. 

Solver must first be enabled to confirm:

  1. In Excel, click File:



  2. Click Options:



  3. Click (1) Add-Ins and in the Manage box to the right of Excel Add-ins, click (2) Go:



  4. In the Add-Ins available box, select the Solver Add-in check box and click OK:

To check if solver is working, please download the following example: SolverTest.xlsx 

If an error occurs at any point during this process, Excel should be repaired.

  1. Open the file in Excel and click Data > Solver:



  2. Click Solve:

  3. If you are presented with results, Solver and the VBA module are working:







Related content

Troubleshooter - SigmaXL for Windows
Troubleshooter - SigmaXL for Windows
More like this
Verify Excel Version and Build Number
Verify Excel Version and Build Number
More like this
Determine the Version and Build of Microsoft Excel
Determine the Version and Build of Microsoft Excel
More like this
Compile error in hidden module: 'thisworkbook' when opening SigmaXL
Compile error in hidden module: 'thisworkbook' when opening SigmaXL
More like this
Resolve Run-time error '5'
Resolve Run-time error '5'
More like this
Run-time error '35' when opening SigmaXL
Run-time error '35' when opening SigmaXL
More like this