Office Settings & Configuration

Fix the Missing Solver Add-in on the Excel Data Tab

Elise WilliamsElise Williams Nov 18, 2026 868 views

Question details

The user needs to restore the Solver command to the Excel Data tab.

Fix the Missing Solver Add-in on the Excel Data Tab
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to use the Solver Add-in after completing the usual setup steps.
Observed behavior
The Solver command is not available on the Data tab.
Before you start

Open Excel and check the Data tab for the Solver command. Use the instructions for your operating system to verify that the Solver Add-in is enabled.

Solution 1Recommended

Enable the Solver Add-in in Excel for Windows

Use Excel's Add-ins settings to turn on Solver and restore its command to the Data tab.

1
Open Add-ins settings

In Excel, select File > Options > Add-ins.

2
Manage Excel Add-ins

In the Manage box, select Excel Add-ins, then select Go.

3
Enable Solver

Check Solver Add-in and select OK.

4
Check the Data tab

Select the Data tab and look for Solver. If it does not appear immediately, close and restart Excel, then check the Data tab again.

Enable the Solver Add-in in Excel for Windows
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface and support for common Excel formats, making it easy to move between spreadsheet applications. It does not fix Excel's missing Solver Add-in.

Open and edit Microsoft Excel XLS and XLSX files.Work with spreadsheet formulas and data in WPS Spreadsheet.Use a familiar interface for everyday spreadsheet tasks.Choose a free, lightweight office suite for working across common document formats.
microsoft office alternative - wps office

Frequently Asked Questions

Where is Solver located after I enable it?

Open Excel's Data tab and look for the Solver command. If it does not appear immediately, restart Excel and check the Data tab again.

How do I check whether Solver is enabled in Windows?

Select File > Options > Add-ins. Choose Excel Add-ins in the Manage box, select Go, and check whether Solver Add-in is selected.

How do I turn on Solver in Excel for Mac?

Select Tools > Excel Add-ins, enable Solver Add-in, and confirm your selection. Then check the Data tab.

Does installing WPS Office restore Solver in Microsoft Excel?

No. Solver is an Excel Add-in, so you need to enable it in Excel. WPS Office is a separate alternative for working with compatible spreadsheet files.