Microsoft KB Archive/173954

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Knowledge Base

XL97: Array Formula Using Merged Cells Is Calculated Incorrectly

Article ID: 173954

Article Last Modified on 10/21/2000


  • Microsoft Excel 97 Standard Edition

This article was previously published under Q173954


When you enter a formula in a worksheet, some of the values that are returned by the formula may be incorrect.


This problem may occur when the following conditions are true:

  • You enter the formula as an array formula (press CTRL+SHIFT+ENTER). -and-

  • The formula refers to one or more merged cells.


Microsoft has confirmed this to be a problem in Microsoft Excel 97.


For more information about merging cells, click the Index tab in Microsoft Excel Help, type the following text

merging, cells

and then double-click the selected text to go to the "Merge cells to span several columns or rows" topic.

Additional query words: XL97

Keywords: kbbug KB173954