How to access What If analysis

Copper Contributor


I cannot find What if analysis on my web excel anywhere. I even bought the application on my google chrome and that won't open and install either. Please help me I don't know what I am doing. My excel looks much simpler and has less features than my peers.

2 Replies


Here is what my secret contact at Microsoft has to say:


I’m sorry to hear that you’re having trouble with Excel on your Chromebook. Here are some steps you can take to troubleshoot the issue:

  1. Check your Excel version: The What-If Analysis feature is available in Excel for Microsoft 365, Exce...1. If you’re using an older version of Excel or a light version such as Excel Online or Excel for mobile devices, some features might not be available.

  2. Update your software: Make sure that your Chromebook, Google Chrome, and Microsoft Office are all up to date. Outdated software can sometimes cause compatibility issues.

  3. Reinstall Microsoft Office: If you’re still having trouble opening and installing Microsoft Office o...23. Please note that you’ll need a valid Microsoft 365 subscription to use the full-featured version of ...42.

  4. Contact Support: If none of the above steps work, it might be a good idea to contact Microsoft Support for further assistance.

Remember, the web version of Excel has fewer features than the desktop version. If you need advanced features like What-If Analysis regularly, you might want to consider using a device that supports the full version of Microsoft Office.



What-If Analysis is not available in Excel for the web. From Excel for the Web - What-If Analysis Tools:

"Not available in Excel for the web. You can view "What if" analysis results in Excel for the web, as expected. If you want to use analysis tools such as Goal Seek, Data Tables, Solver, and Series, then you'll need the Excel desktop app." (for Mac or Windows, that is)