XL97: Cannot Show Scenario That Includes Merged Cells

Last reviewed: January 9, 1998
Article ID: Q168603
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SYMPTOMS

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

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

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

CAUSE

This problem occurs if any of the changing cells in the scenario are merged cells.

RESOLUTION

In Microsoft Excel 97, 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 this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

In Microsoft Excel 97, you can merge a number of cells into a single cell by performing the following 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.

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

You can add a scenario to a worksheet by performing the following steps:

  1. On the Tools menu, click Scenarios. Click Add.

  2. In the Scenario Name edit box, type a name for your new scenario. In the Changing Cells edit box, enter a reference to the cells that you want to include in the scenario. Then, click OK.

  3. In the Scenario Values dialog box, enter a value for each changing cell. When you are finished, click OK.

  4. In the list of Scenarios, select the scenario you want to show, and then click Show.

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


Additional query words: 97 XL97
Keywords : xlformat xlwgroups
Version : WINDOWS:97
Platform : WINDOWS
Hardware : x86
Issue type : kbprb
Solution Type : Info_Provided


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: January 9, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.