Microsoft KB Archive/93193

Microsoft Knowledge Base

Excel: Using More Than Nine Changing Cells in Scenario Manager

Last reviewed: July 12, 1996
Article ID: Q93193

The information in this article applies to:

• Microsoft Excel for Windows, version 4.0
• Microsoft Excel for the Macintosh, version 4.0

SUMMARY

The Scenario Manager in Microsoft Excel supports up to 6,400 changing cells. However, the Add Scenario dialog box allows you to set values for only nine changing cells. To use more than nine changing cells, specify the full range you want to use in the Changing Cells box in the Scenario Manager dialog box.

MORE INFORMATION

The Scenario Manager allows you to record and save different sets of input values that you can substitute in your worksheet model when performing "what if" analysis. The cells on your worksheet that contain these input values are called changing cells. That is, these are the cells containing values that may change with different scenarios.

When you have more than nine changing cells, the following message is displayed at the bottom of the Add Scenario dialog box:

   Current values used for additional changing cells

This message means that Microsoft Excel is using the current values in these cells on your worksheet for the scenario you are adding.

To create a scenario using more than nine changing cells, enter the values you want to use in the changing cells on the worksheet and add your new scenario.

To create a scenario using more than nine changing cells:

1. From the Formula menu, choose Scenario Manager.

   If Scenario Manager doesn't show up on the Formula menu, exit Microsoft Excel and run the Microsoft Excel Setup program to install it. You may also add it through the Add-In Manager by by choosing Add-ins from the Options menu, then selecting the Add button and highlighting scenario.xla and choosing OK.

2. In the Scenario manager dialog box, make sure that the contents of the Changing Cells box are selected.

3. Select the cells on your worksheet that you want to use as the changing cells for this scenario.

   As you select cells, Microsoft Excel enters the cell references in the Changing Cells box in the Scenario Manager dialog box.

   Note: To select non-adjacent cells, hold down the CTRL key (COMMAND on the Macintosh) as you select your changing cells.

4. In the Scenario Manager dialog box, choose the Add button.

5. In the Add Scenario dialog box, type a name for this scenario in the Name box.

   Notice that Microsoft Excel enters the values from your worksheet in the nine boxes displayed in the Add Scenario dialog box.

6. In the Add Scenario dialog box, choose the OK button.
7. In the Scenario Manager dialog box, choose the Close button.
8. On your worksheet, type the values you want for your next scenario in the changing cells you selected.
9. Repeat steps 1 through 7.

Microsoft Excel saves your scenario, using the values from your worksheet and the name you provided.

To view your scenario:

1. From the Formula menu, choose Scenario Manager.
2. In the Scenario Manager dialog box, select the scenario you want to view from the Scenarios list.

3. Choose the Show button.

   Microsoft Excel enters the values you saved with this scenario in the changing cells on your worksheet and your worksheet is recalculated to reflect these new values.

4. Choose the Close button.

REFERENCES

"Microsoft Excel User's Guide 2," version 4.0, pages 67-74

KBCategory: kbusage KBSubcategory: Additional reference words: 4.0 4.00 edit scenerio THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Last reviewed: July 12, 1996 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.