Forum Discussion
mkouf
Sep 11, 2023Copper Contributor
How to access What If analysis
Hello,
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
Sort By
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)
- Detlef_LewinSilver Contributor
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:
Check your Excel version: The What-If Analysis feature is available in Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, and Excel 20131. 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.
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.
Reinstall Microsoft Office: If you’re still having trouble opening and installing Microsoft Office on your Chromebook, you might want to try uninstalling and then reinstalling it23. Please note that you’ll need a valid Microsoft 365 subscription to use the full-featured version of Office on a Chromebook42.
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.