Does Excel Goal Seek Automatically Update?

How-to basics · Updated November 19, 2026

No. Excel Goal Seek finds an input value that makes a formula reach a target, then leaves that value in the changing cell; it does not keep rerunning the search when other cells change. The formula will recalculate normally, but if you need Goal Seek to find a new input, you must run it again.

What Goal Seek changes—and what it does not

Goal Seek is a one-variable what-if analysis tool in the desktop versions of Excel. You tell it which formula cell to set, the result you want, and which single input cell Excel may change. Excel tries different values in that input cell until the formula gets close to the target. It then writes the resulting value into the worksheet.

That last detail explains much of the confusion around automatic updates. Goal Seek does not create a permanent relationship between the target and the changing cell. It does not add a new formula, preserve a live instruction, or watch the workbook for changes. Once the search finishes, the changing cell simply contains a value. If a related assumption changes later, formulas recalculate using that value, but Excel does not search for a replacement value on its own.

For example, Goal Seek can find the unit price that produces a chosen sales total at a particular quantity. If the quantity later changes, the sales formula updates, but the price remains what Goal Seek last entered. The new sales total may therefore no longer match the target.

How to run Goal Seek in Excel

In Excel for Microsoft 365 on Windows, prepare a formula cell and a separate input cell, then choose Data > What-If Analysis > Goal Seek. In the dialog, fill in these three fields:

  • Set cell: The cell containing the formula whose result should reach the target.
  • To value: The desired result, entered as a number rather than as a cell reference or formula.
  • By changing cell: The input cell Excel is allowed to adjust. It must affect the formula in the Set cell.

Choose OK to let Excel search. When it finishes, the Goal Seek Status dialog reports whether it found a solution or reached its stopping point. Choose OK to keep the proposed value, or Cancel to restore the changing cell to its previous value. Check the worksheet afterward: Goal Seek can return a close numerical result rather than an exact match.

It is sensible to save a copy before experimenting, especially in a model with many dependent formulas. Goal Seek changes a cell value, and accepting the result does not add a record of the original assumption to the workbook.

A simple example: finding a price for a sales target

Suppose B2 contains a unit price, C2 contains the number of units sold, and D2 calculates revenue. With those cell assignments, enter this formula in D2:

=B2*C2

If C2 contains 80 and the goal is revenue of 1,200, open Goal Seek and set the cell to D2, the target value to 1200, and the changing cell to B2. Excel can set B2 to 15, because 15 multiplied by 80 equals 1,200. The result is a value in B2, not a new formula that continually calculates the required price.

Now change C2 to 100. D2 recalculates to 1,500 because the price remains 15. To keep revenue at 1,200, run Goal Seek again with D2 as the Set cell, 1200 as the target, and B2 as the changing cell. Excel should then find a price of 12. This illustrates the distinction: ordinary recalculation is automatic, but the optimization search is not.

The example also shows why cell roles matter. Goal Seek needs a formula in the Set cell and a changing cell that influences that formula. If you choose a cell that the formula does not depend on, changing it cannot move the result toward the target.

What updates automatically after the search

After you accept a Goal Seek result, Excel recalculates formulas that depend on the changed input, subject to the workbook’s calculation settings. Totals, charts, and other formulas linked to those cells may consequently display new results. This is normal spreadsheet calculation; it is not Goal Seek running again.

The target is not enforced as a rule. If a different input changes the formula’s result, Excel does not alter the Goal Seek input to compensate. Likewise, changing the target number in a worksheet cell has no effect on a past Goal Seek operation. The target entered in the dialog was used for that search only.

This distinction matters when a workbook is used as a planning model. A value that was once found by Goal Seek can look like an ordinary assumption later. Add a note, use a clearly labelled input cell, or keep a separate copy of the original scenario so another person can see what the value represents and when it was calculated.

Calculation settings are separate from Goal Seek

Excel’s calculation mode controls when formulas recalculate; it does not control whether Goal Seek repeats. With automatic calculation enabled, formulas generally update when their precedent cells change. With manual calculation, formula results may remain stale until you recalculate, but Excel still does not rerun the search that selected the changing-cell value.

In Excel for Microsoft 365 on Windows, check the setting at Formulas > Calculation Options. If the workbook is in Manual mode, choose Automatic if that is appropriate for the file, or recalculate when needed. Press F9 on Windows to calculate open workbooks. On a Mac, calculation controls and shortcuts can differ by keyboard and Excel release; the Formulas tab includes calculation options, and users can consult the shortcut list for their particular Mac setup.

Do not confuse this setting with Excel’s iterative calculation option. Iterative calculation is intended for formulas with circular references, where a formula depends directly or indirectly on its own result. It is not a switch that makes Goal Seek continuously solve a model.

Why a Goal Seek result may not update as expected

If a displayed formula result appears unchanged after you accept a solution, first check whether calculation is set to Manual. Also confirm that the Set cell contains a formula and that it actually depends on the changing cell. A typo in a cell reference, a disconnected input, or a formula pointing to a different assumption can make the result seem unresponsive.

Goal Seek works with one changing cell at a time and searches numerically. It may not find a useful answer if the formula cannot reach the requested target, if the input is constrained by logic in the model, or if the starting value leads the search toward an unsuitable solution. Nonlinear formulas can have multiple possible answers, and a different starting value may lead to a different result. Inspect the proposed value and the resulting formula rather than assuming every reported solution is meaningful.

Goal Seek also does not impose practical limits by itself. If a price must be positive, a staffing level must be a whole number, or a budget cannot exceed a cap, review the result against those requirements. Goal Seek does not automatically enforce such business constraints. For a complex formula, try a sensible starting estimate and make sure the model behaves consistently across the values Excel may test.

When to use Goal Seek, Solver, or a data table

Goal Seek is a good fit when one output has a target and exactly one input is allowed to change. It is quick for questions such as how many units are needed to reach a specified total, or what single rate would produce a particular calculated payment. It is not designed to find the best outcome among many choices or to adjust several inputs together.

  • Use Goal Seek for one target formula and one changing cell. Run it again whenever the assumptions or target change and you need a new answer.
  • Use Solver when the model needs to optimize a result, change multiple cells, or respect constraints. Solver is an Excel add-in; availability and setup can vary by platform.
  • Use a one-variable or two-variable data table to compare formula results across a range of input values. A data table displays scenarios; it does not select and permanently enter the one input that meets a target.

These tools answer related but different questions. A data table is useful when you want to see how results vary across many assumptions. Goal Seek works backward from one desired result. Solver handles broader optimization problems. None should be described as making a past Goal Seek operation automatically update.

Desktop, Mac, and web availability

The instructions above use Excel for Microsoft 365 on Windows. Excel for Mac also includes Goal Seek in desktop Excel; the exact arrangement of ribbon commands can vary with the release, so look under the Data tab for What-If Analysis and Goal Seek. A Windows ribbon path or keyboard shortcut should not be assumed to match on a Mac.

Excel for the web does not provide the full desktop Goal Seek command. If you need to run a new search, open the workbook in the Excel desktop app. A value previously entered by Goal Seek can still be part of the workbook, and formulas may calculate in the web version, but that does not mean the web app is rerunning the search.

Frequently Asked Questions

Does Goal Seek recalculate when I change another cell?
Excel recalculates dependent formulas according to the workbook’s calculation mode, but Goal Seek does not rerun. The value in its changing cell stays as it was until you run another search or edit it.

Can Goal Seek keep a result at a target automatically?
No. Goal Seek performs a one-time search and writes a value into the changing cell. It does not monitor the target or continually adjust that input as the model changes.

Why did my Goal Seek result stop matching the target?
A dependent assumption may have changed after the search, or calculation may be set to Manual. Recalculate formulas if needed, then run Goal Seek again with the correct formula cell, target, and changing cell.

Can Goal Seek change more than one cell?
No. Goal Seek has one changing-cell field. Use Solver if the problem requires changing multiple inputs or applying constraints to them.

Can I use Goal Seek in Excel for the web?
The full Goal Seek command is not available in Excel for the web. Open the workbook in desktop Excel for Microsoft 365 on Windows or Excel for Mac to run the analysis.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.