Office Compatibility Issues

Where to Find What-If Analysis in Excel for the Web

Kushani NimanthikaKushani Nimanthika Nov 14, 2026 868 views

Question details

The user wants to find What-If Analysis tools when the command and desktop Options menu are not visible.

Product
Microsoft Excel for the web
Device & OS
not provided
Scenario
The user wants to use tools such as Goal Seek, Data Tables, or Scenario Manager in a web or education version of Excel.
Observed behavior
The What-If Analysis command and the desktop File > Options menu are not shown.
Before you start

Check whether you are using Excel in a browser or the installed desktop app. If you plan to open the workbook in desktop Excel, make sure the app is installed and your account has access to it.

Solution 1Recommended

Open the workbook in desktop Excel to use What-If Analysis

Use the desktop app when the What-If Analysis tools you need are unavailable in Excel for the web.

Goal Seek, Data Tables, and Scenario Manager may not be available in Excel for the web. Desktop feature availability can also depend on your Excel version and license.

1
Open the workbook in the app

In Excel for the web, use the Open in Desktop App command, which may appear under Editing or File, to open the workbook in installed Excel.

2
Find What-If Analysis

In desktop Excel, select the Data tab and look in the Data Tools group for What-If Analysis.

3
Choose a tool

Select What-If Analysis, then choose Goal Seek, Data Table, or Scenario Manager as needed.

Open the workbook in desktop Excel to use What-If Analysis
Check your license: An education account may not include the desktop app. If you cannot open or activate desktop Excel, check your school’s license or contact its administrator.
Free Microsoft Office alternative

Work with Excel files in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel formats, making it easier to move existing workbooks between office suites. It does not add missing commands to Excel for the web.

Open and edit spreadsheet workbooks in a familiar interfaceCompatible with Microsoft Excel formats such as XLSX and XLSReview workbook calculations in WPS SpreadsheetsFree and lightweight for everyday office work
microsoft office alternative - wps office

Frequently Asked Questions

Can I add What-If Analysis through File > Options in Excel for the web?

Excel for the web does not provide the desktop File > Options menu. Open the workbook in desktop Excel and check Data > What-If Analysis instead.

Where is Goal Seek in desktop Excel?

Open the workbook in desktop Excel, select the Data tab, and choose What-If Analysis > Goal Seek in the Data Tools group.

Does an education account include desktop Excel?

It depends on the school’s license. Check the apps available through your school account or ask your administrator whether desktop Excel is included.

What if What-If Analysis is still missing in desktop Excel?

Confirm that you opened the installed desktop app rather than the browser version, then check the Data tab. Feature availability can depend on the application version and license.