'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Perform Sensitivity Analysis in Excel Online
Question details
Users need to create and view sensitivity analysis models (What-If Data Tables) via a web browser.
- Product
- Excel Online
- Device & OS
- not provided
- Scenario
- Attempting to create sensitivity tables online and synchronize the calculation results across platforms.
- Observed behavior
- Excel for the web currently lacks the built-in Sensitivity Analysis or What-If Data Table tools that are available in the desktop version.
Ensure you have access to the desktop version of Microsoft Excel and an active OneDrive or SharePoint account to synchronize your workbooks.
Create the Sensitivity Analysis in Desktop Excel and Sync Online
Since Excel for the web does not support creating What-If Data Tables, you must create them on your desktop app and sync the file to view it online.
Excel Online is designed as a lightweight editor and currently omits advanced analytical tools like What-If Analysis. To work around this, the initial setup of your data table must be done on a local machine.
Launch the desktop version of Microsoft Excel and open the workbook where you want to perform the sensitivity analysis.
Navigate to the 'Data' tab on the ribbon, click on 'What-If Analysis', and select 'Data Table' to input your row and column variables.
Save the completed workbook directly to your connected OneDrive or SharePoint account.
Open Excel Online in your web browser and access the synced workbook. The table will display and recalculate based on input changes, although you cannot alter the table's core structure from the web interface.
Perform Sensitivity Analysis Easily with WPS Office
Avoid web-based feature limitations by using WPS Office. WPS Spreadsheets offers a robust, free desktop application that natively supports What-If Analysis and Data Tables, ensuring your sensitivity analysis works flawlessly.
- 1. Install WPS Office: Download and install the free WPS Office suite on your computer.
- 2. Open your file: Launch WPS Spreadsheets and open your existing .xlsx workbook.
- 3. Access What-If Analysis: Go to the 'Data' tab on the top ribbon.
- 4. Set up your Data Table: Click on 'What-If Analysis' and select 'Data Table' to easily configure the variables for your sensitivity analysis.
Frequently Asked Questions
Why is What-If Analysis missing in Excel Online?
Excel Online is a streamlined version of the desktop application designed primarily for basic editing and real-time collaboration. Complex calculation tools like What-If Analysis and Data Tables are currently restricted to the full desktop version.
Will my sensitivity analysis update automatically in Excel for the web?
Yes, if you change the input variables that are linked to the data table, Excel Online will successfully recalculate the results based on the existing table structure that was created on the desktop.
Can I use third-party add-ins for sensitivity analysis in Excel Online?
While Excel Online supports some web-based Office Add-ins, native functionality for complex What-If Data Tables relies on the desktop calculation engine. It is highly recommended to perform these analyses on the desktop app before uploading.
Does WPS Office support What-If Analysis natively?
Yes, WPS Spreadsheets includes full built-in support for What-If Analysis, including Goal Seek, Scenario Manager, and Data Tables, and remains completely compatible with Excel file formats.
