Microsoft KB Archive/248181

From BetaArchive Wiki
Knowledge Base

XL2000: Crash When Pasting Array Formulas into Merged Cells

Article ID: 248181

Article Last Modified on 11/5/2003


  • Microsoft Excel 2000 Standard Edition

This article was previously published under Q248181


If you copy a range of cells containing an array formula and paste it to another range, Excel may crash, and you may receive the following error message:

This program has performed an illegal operation and will be shut down.

If the problem persists, contact the program vendor.

If you click Details, you receive an error message similar to the following:

Excel has caused in invalid page fault in module EXCEL.EXE at 015f:30070f2d.


This problem occurs when the following conditions are true:

  • You copy a range containing an array formula and paste it into another range.


  • The target range for the paste operation contains a merged cell.


  • The merged cell is not part of the first row or first column of the paste region.


To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)


Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.

Additional query words: XL2000 crash crashes crashing crashed quit quitting quits fail fails failing failed break

Keywords: kbbug kbfix KB248181