Office Compatibility Issues

Where to Find What-If Analysis and Data Tables in Excel for iPad

Natalie Taylor Oct 9, 2026 868 views

Question details

The user is trying to locate the What-If Analysis and Data Tables features in the Excel mobile app for iPad but cannot find them in the interface.

Product: Microsoft Excel
Device & OS: iPad
Scenario: Attempting to create or modify Data Tables for predictive modeling and scenario testing on an iPad.
Observed behavior: The What-If Analysis tools, including Data Tables and Goal Seek, are completely missing from the Excel for iPad ribbon interface.

Before you start

Ensure that your workbook is synced to a cloud service like OneDrive so you can seamlessly transition to a desktop computer if advanced data tools are required.

Solution 1Recommended

Use Desktop Excel for Full Functionality

Since Excel for iPad does not support the creation of Data Tables or What-If Analysis, switching to the desktop version is the most reliable solution.

Microsoft limits advanced data manipulation features on mobile platforms to streamline the interface and optimize performance. To create or extensively edit What-If Analysis scenarios, you must use a Windows or Mac computer.

Save your iPad workbook

Tap the cloud icon or save menu in Excel for iPad to ensure your latest changes are synced to OneDrive or iCloud.

Open on a Desktop

Launch the desktop version of Microsoft Excel on your PC or Mac and open the recently synced file.

Access What-If Analysis

Navigate to the Data tab on the top ribbon, click on 'What-If Analysis', and select 'Data Table' to proceed with your advanced analysis.

Use Desktop Excel for Full Functionality

Solution 2

Use Formulas and PivotTables as Workarounds

If you are restricted to using only your iPad, you can replicate some basic What-If behaviors using standard formulas or PivotTables.

Free Microsoft Office alternative

Analyze Complex Data Effortlessly with WPS Office

Don't let mobile app limitations slow down your productivity. WPS Office offers a powerful, lightweight, and completely free desktop alternative that provides comprehensive data analysis tools, including What-If Analysis and Goal Seek, with a familiar user interface.

1. Download and Install: Get WPS Office for free from the official website and install it on your computer.
2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx workbook.
3. Use Advanced Tools: Navigate to the Data tab to instantly access robust What-If Analysis and forecasting tools.

Fully compatible with Microsoft Excel formats (.xlsx, .xls)Includes advanced data features like What-If Analysis and Goal Seek out of the boxLightweight installation that runs flawlessly on Windows, Mac, and LinuxFamiliar ribbon interface requires no learning curve to switch

microsoft office alternative - wps office

Frequently Asked Questions

Will Microsoft add What-If Analysis to the iPad version of Excel?

Microsoft frequently updates its mobile applications, but advanced analytical tools like What-If Analysis are resource-intensive and historically prioritized exclusively for desktop environments (PC and Mac).

Can I view existing Data Tables on my iPad?

Yes. If a Data Table was previously created on a desktop and the file is opened on an iPad, the table will display its calculated values. However, modifying the inputs to recalculate the table is not supported.

Is Goal Seek available in Excel for iPad?

No, Goal Seek is categorized under the What-If Analysis toolset, which means it is also unavailable in the Excel for iPad application.

Are there any iOS add-ins that enable What-If Analysis?

Currently, Excel for iOS has limited support for third-party add-ins, and there are no official add-ins that fully restore native What-If Analysis or Data Table generation on the iPad.

Office App Problems