What If Analysis Not Showing in Excel

Trying to model a few different business outcomes in Excel, but the "What-If Analysis" button is completely missing from your Data tab? It’s a frustratingly common problem, but the fix is usually quick and painless. This article will show you exactly how to get the What-If Analysis tools (including Goal Seek and Scenario Manager) showing up where they belong.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why Is What-If Analysis Missing in Excel?

More often than not, the "What-If Analysis" feature isn't lost, it's just not turned on. This set of tools is part of a special Excel "Add-in" called the Analysis ToolPak. Add-ins are extra sets of features that aren't enabled by default for every user because they pack a bit more analytical horsepower than the average person might need.

In 99% of cases, your What-If Analysis button is missing because the Analysis ToolPak add-in is disabled. In very rare cases, the entire command group on the Excel ribbon has been accidentally hidden through customization. We'll start with the most common and easiest fix first: enabling the add-in.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

How to Enable What-If Analysis (The Analysis ToolPak)

Activating the Analysis ToolPak is a few clicks away. Once you enable it, the add-in remains active for all future Excel sessions unless you manually disable it again. The process is slightly different for Windows and Mac users.

For Excel on Windows:

Follow these steps to enable the add-in and get the What-If Analysis button back on your ribbon:

1. Click on the File tab in the top-left corner of your Excel window.
2. In the menu that appears on the left, click Options at the very bottom.
3. The "Excel Options" window will pop up. In this window's left-hand menu, select Add-ins.
4. You'll now see a list of add-ins. At the very bottom of this window, you'll see a dropdown menu labeled "Manage." Make sure it's set to Excel Add-ins and then click the Go... button.
5. Another smaller "Add-ins" window will appear. Find Analysis ToolPak in the list and check the box next to it.
6. Click OK.

That's it! When you return to your sheet, click on the Data tab in your main ribbon. You should now see the What-If Analysis button within the "Forecast" or "Data Tools" group.

For Excel on Mac:

The process on a Mac is just as simple, but the menu locations are different.

1. Click on the Tools menu in the main menu bar at the very top of your screen.
2. From the dropdown menu, select Excel Add-ins...
3. The Add-ins window will appear. Check the box next to Analysis ToolPak.
4. Click OK.

Now, click on the Data tab in the Excel ribbon. The What-If Analysis tools will be present and ready to use.

A Quick Refresher: What's Inside What-If Analysis?

Now that you've got the button back, let's do a quick rundown of the powerful tools you've just unlocked. What-if analysis is all about changing input values in your models to see how those changes affect the outcome, helping you make better, more informed decisions. It contains three main features.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Goal Seek

Goal Seek works backward to find an unknown input value for you. You tell Excel what result you want in a formula cell (the "goal"), and Goal Seek figures out what a specific input cell needs to be to achieve that goal.

• Perfect for a question like: "We want to hit exactly $100,000 in monthly revenue. Based on our average order value, how many units do we need to sell?"
• How it works: You specify the formula cell (Revenue), the target value ($100,000), and the cell you want Excel to change (Units Sold). Goal Seek then runs through the numbers until it finds the answer.

Scenario Manager

Scenario Manager lets you build and save different groups of input values as named scenarios. You can then quickly toggle between them to see their impact on your model, which is much better than manually changing multiple cells every time.

• Perfect for a question like: "How will our project's profitability change based on a Best Case, Worst Case, and Most-Likely Case projection for costs and sales?"
• How it works: You define a "Best Case" scenario where you set values for, say, ad spend, conversion rate, and staff costs. You do the same for a "Worst Case" scenario and a "Most-Likely" scenario. Scenario Manager lets you swap between these instantly without re-typing anything. You can even generate a summary report comparing all scenarios side-by-side.

Data Tables

Data tables allow you to see how changing one or two input variables in a formula affects the result, all neatly displayed in a table. It's a quick and powerful way to see a range of possible outcomes at a glance.

• Perfect for a question like: "How does our product's gross profit change if we vary the selling price between $20 and $50 and the cost of goods sold between $8 and $15?"
• How it works: A one-variable data table shows how a list of different input values (e.g., selling prices) affects one or more formulas. A two-variable data table uses both a row of inputs (e.g., selling prices) and a column of inputs (e.g., costs) to show how they interact to affect a single formula's outcome.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Still Missing? How to Check Your Ribbon Customization

If you enabled the Analysis ToolPak and the What-If Analysis button is still nowhere to be found, there's a small chance the command group on the "Data" tab was hidden. This is rare, but here's how to check and fix it.

This process is only available for Excel on Windows.

1. Right-click anywhere on the Excel ribbon (like on the word "Data") and select Customize the Ribbon... This will open the Excel Options window directly to the correct section.
2. On the right side of the window, you'll see a list of "Main Tabs." Make sure the box next to Data is checked.
3. Click the little "+" sign next to "Data" to expand it and reveal all the command groups within that tab.
4. Look for a group named Forecast (or sometimes Data Tools in older Excel versions). This is where What-If Analysis lives. If it's missing, you may need to add it back.
5. If you see the Forecast group but it’s grayed out or you suspect it’s corrupt, you can reset just the Data tab. At the bottom right, click the Reset dropdown and select Reset only selected Ribbon tab. This will restore the Data tab to its default layout, which includes the What-If Analysis group (as long as the add-in is active).
6. Click OK to save your changes.

Resetting the ribbon tab will resolve any customization issues and should, combined with enabling the add-in, bring your What-If Analysis tools back where they belong.

Final Thoughts

Having your "What-If Analysis" button disappear can disrupt your workflow, but the solution is usually just a few clicks away. By enabling the Analysis ToolPak via the Add-ins menu, you can restore its powerful features - Scenario Manager, Goal Seek, and Data Tables - and get back to modeling your business decisions.

While Excel's tools are fantastic for detailed scenario planning once you get them running, sometimes you need immediate answers from your business data without building complex spreadsheets. We created Graphed for precisely that reason. Instead of wrangling add-ins and modeling scenarios manually, we let you connect data from sources like Shopify, Google Analytics, and Salesforce, then simply ask your questions in plain English - like "what's the relationship between our ad spend and total sales over the last quarter?" - and get an instant dashboard in seconds.