Microsoft KB Archive/211840

= XL2000: Cannot Show Scenario That Includes Merged Cells =

Article ID: 211840

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211840





SYMPTOMS
When you use the Scenario Manager to show a scenario in Microsoft Excel 2000, you may receive the following error message:

Some changing cells are part of an array or table and cannot be changed.

You may receive this message even though none of the changing cells are part of an array or a table.



CAUSE
This behavior can occur if any of the changing cells in the scenario are merged cells.



RESOLUTION
In Excel 2000, you cannot show a scenario that includes any merged cells. Make sure that you do not add any merged cells to your scenario when you create or edit it.



STATUS
Microsoft has confirmed that this is a problem in Excel 2000.



MORE INFORMATION
In Excel 2000, you can merge a number of cells into a single cell; to do so, follow these steps:
 * 1) Select the cells that you want to merge.
 * 2) On the Format menu, click Cells, click the Alignment tab, click to select the Merge cells check box, and then click OK.

NOTE: You can also merge cells by selecting the cells and clicking the Merge and Center button on the Formatting toolbar.

To add a scenario to a worksheet, follow these steps:
 * 1) On the Tools menu, click Scenarios, and then click Add.
 * 2) In the Scenario name edit box, type a name for your new scenario. In the Changing cells edit box, type a reference to the cells that you want to include in the scenario, and then click OK.
 * 3) In the Scenario Values dialog box, type a value for each changing cell. When you are finished, click OK.
 * 4) In the Scenarios list box, select the scenario that you want to show, and then click Show.

If any of the changing cells are merged cells, you receive the error message cited in the "Symptoms" section.

Additional query words: XL2000

Keywords: kbbug kbpending KB211840

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.