XL97: Calculating Worksheet Causes Crash After Running Module

• Microsoft Excel 97 for Windows

SYMPTOMS

When you calculate your worksheet, error messages similar to the following may appear:

Microsoft Windows 95

   This program has performed an illegal operation and will be
   shut down. If the problem persists, contact the program vendor.

   Excel caused an invalid page fault in module Excel.exe at
   0137:3022d421.

Microsoft Windows NT

   Dr. Watson for Windows NT
   An application error has occurred and an application error log is
   being generated.

   Excel.exe

   Exception: access violation (0xc0000005), Address 0x3022d41.

CAUSE

This problem may occur when the following conditions are true:

• Your workbook is set to manual calculation mode.

      -and-
  

• You run Microsoft Visual Basic for Applications code that performs a Copy operation on a range of cells that contain a formula entered as an array.

      -and-
  

• The Visual Basic code performs a Paste Special operation with the copied cells, pasting only the values into the worksheet.

      -and-
  

• You calculate your worksheet.

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.

REFERENCES

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

   calculating formulas, changing method