Where to Find What-If Analysis in Excel for the Web
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.
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.
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.
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.
In desktop Excel, select the Data tab and look in the Data Tools group for What-If Analysis.
Select What-If Analysis, then choose Goal Seek, Data Table, or Scenario Manager as needed.

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.

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.




