How to Get Data Solver in Excel

Excel has a powerful optimization tool hiding right under the surface, but you won't find it in the ribbon by default. It's called the Solver Add-in, and it’s designed to find the best possible outcomes for complex problems involving multiple variables and constraints. This guide will show you exactly how to enable the Solver in your version of Excel and walk through a practical example of how to use it for a common business problem.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Is the Excel Solver, Exactly?

Think of the Solver as a GPS for your data. You tell it where you want to go (your objective), what roads you have to take or avoid (your constraints), and which parts of the route you can change (your variables). Solver then does the heavy lifting, running through different scenarios to calculate the optimal path to reach your goal.

More technically, it's an optimization tool that helps you perform advanced "what-if" analysis. It’s perfect for answering questions like:

• How can we allocate our marketing budget across different channels to get the maximum number of leads?
• What is the most efficient production schedule to minimize costs while meeting customer demand?
• How should we adjust our product pricing to maximize our total profit margin?

While standard Excel formulas and PivotTables are great for summarizing what has happened, the Solver is a fantastic tool for figuring out what you should do next to achieve a specific business goal.

How to Get the Solver in Excel

The Solver is a built-in add-in, which means the functionality is already included with Excel, you just need to activate it. The process is slightly different for Windows and Mac users.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Enabling Solver on Windows

Activating the Solver on a Windows PC only takes a minute. Just follow these steps:

1. Click on File in the top-left corner, then select Options at the bottom of the left-hand menu.
2. In the Excel Options window that appears, click on Add-ins from the sidebar.
3. At the bottom of the window, you'll see a dropdown menu next to the word "Manage." Make sure it says Excel Add-ins and then click the Go... button.
4. A small "Add-ins" window will pop up. Check the box next to Solver Add-in and click OK.

That's it! To confirm it worked, go to the Data tab in your Excel ribbon. You should now see a "Solver" button in the "Analyze" group, usually on the far right.

Enabling Solver on Mac

For Mac users, the steps are just as straightforward:

1. With Excel open, click on Tools in the top menu bar (next to File, Edit, View, etc.).
2. From the dropdown menu, select Excel Add-ins....
3. In the window that appears, simply check the box next to Solver Add-in and click OK.

Once you've done this, the Data tab in your ribbon will now have a "Solver" button in the "Analyze" group, ready for you to use.

A Practical Example: Using Solver to Optimize a Marketing Budget

Reading instructions is one thing, but seeing Solver in action is the best way to understand its power. Let's walk through a common scenario: you have a monthly marketing budget of $10,000 and want to figure out how to best spend it across several channels to maximize the number of new leads.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 1: Set Up Your Spreadsheet

First, we need to lay out our data in a structured way. Create a simple table like the one below. The key is to have your variables (the amounts you can change), your constraints (the rules you must follow), and your objective (the value you want to maximize or minimize) clearly defined.

Your spreadsheet should have columns for:

• Channel: Google Ads, Facebook Ads, LinkedIn Ads, etc.
• Budget Allocation: This is where you'll put your initial guess for spending. For now, you can divide it up evenly or just input some placeholder numbers. These are the cells Solver will change for you.
• Cost Per Lead (CPL): This is your historical data. How much does it typically cost to get one lead from each channel?
• Leads Generated: This column will contain a formula. Its value is dependent on the budget and CPL.

Here’s how the setup might look:

In cell D2, the formula would be your budget divided by your CPL. In this case:

=B2/C2

Drag this formula down for the other channels.

Next, you need two cells for your totals, which will be essential for the Solver:

• A Total Budget cell (in this example, B5) with a SUM formula for your allocated budget:

=SUM(B2:B4)

• A Total Leads cell (in this example, D5) with a SUM formula for all generated leads:

=SUM(D2:D4)

Lastly, off to the side, state your total available budget clearly (e.g., in cell G1, put "$10,000"). This makes it easy to reference when setting up your constraints.

Step 2: Define the Solver Parameters

Now, go to the Data tab and click the Solver button to open the main window. This is where you'll tell Excel what problem you're trying to solve.

The Solver window has three main sections:

1. Set Objective: This is your primary goal. Click in this box, then click on the cell that represents your main objective. For us, that's maximizing leads, so we'll select our "Total Leads" cell (D5). Below this, choose the Max radio button because we want the highest number of leads possible.
2. By Changing Variable Cells: These are the cells you're allowing Solver to adjust to reach your goal. For this problem, we want to change our budget allocation. So, click and drag to select the cells in your Budget Allocation column (B2:B4).
3. Subject to the Constraints: These are the rules of the game. Our budget and any other business rules need to be added here. Click the Add button to define them one by one.

For our example, let's add three constraints:

• Constraint 1: The budget limit. Our Total Budget (cell B5) must be less than or equal to our available funds (cell G1). So the constraint is B5 <= G1. This is the most important rule.
• Constraint 2: Channel maximum. Let's say we know from experience that spending more than $5,000 on Facebook Ads in a month brings diminishing returns. We can add a constraint that our Facebook Ads budget (cell B3) should be less than or equal to $5,000: B3 <= 5000.
• Constraint 3: Channel minimum. We might want to keep a presence on all channels, even if they aren't the top performer. We can add constraints forcing Solver to allocate at least $500 to each channel. So, you would add three separate constraints: B2 >= 500, B3 >= 500, and B4 >= 500. You could also do this in one go by selecting the range B2:B4 and setting it as >= 500.

Step 3: Run Solver and Interpret the Results

Once your parameters are set, ensure the checkbox for "Make Unconstrained Variables Non-Negative" is ticked (since you can't have negative ad spend). The solving method should be "GRG Nonlinear" by default, which works fine for this type of problem.

Click the Solve button. Excel will run through the calculations and, in a moment, a "Solver Results" dialog box will appear. If all goes well, it will say "Solver found a solution."

You can choose to Keep Solver Solution to update your spreadsheet with the new, optimized numbers, or restore your original values. In the background, you'll see your "Budget Allocation" cells have changed. Solver has re-allocated your $10,000 to maximize leads, all while respecting your budget cap and the other rules you set.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Tips for Using Solver Effectively

• Start Simple: If you're new to Solver, start with a simple model like the one above. As you get more comfortable, you can add more variables and constraints to reflect more complex business realities.
• Double-Check Your Formulas: Solver is only as smart as the spreadsheet you give it. If your "Leads Generated" formula is incorrect, Solver's solution will be, too. Make sure all your underlying calculations are solid.
• "Solver could not find a feasible solution": This is a common error. It usually means your constraints are contradictory. For example, your minimum channel spends might add up to more than your total available budget. Go back and check your constraints to find the one causing the conflict.
• Utilize Reports: After running Solver, you can generate reports (Answer, Sensitivity, and Limits) that give you deeper insights into the solution and how sensitive it is to changes in your constraints.

Final Thoughts

By enabling and learning to use the Excel Solver, you can turn your spreadsheets from simple reporting tools into powerful decision-making engines. It allows you to model complex scenarios and find mathematically optimal solutions for everything from financial planning to resource allocation without ever leaving Excel.

Of course, setting up these models in Excel requires a manual and detailed approach - you have to design the spreadsheet, input the formulas, and carefully define your constraints. Working with marketing and sales data from platforms like Shopify or Google Analytics often means first a lengthy process of exporting CSVs before you can even begin. At Graphed, we help teams skip that manual busywork. By connecting your platforms in a few clicks, you can use simple, natural language to ask for dashboards ("create a report showing sessions vs purchases by channel") and get instant, live-updating answers, freeing you up to focus on strategy instead of painstakingly building reports.