XL97: Calculating Worksheet Causes Crash After Running Module

ID: Q173272

The information in this article applies to:

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.

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

   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.

REFERENCES

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

   calculating formulas, changing method

and then double-click the selected text to go to the "Change the way Microsoft Excel calculates formulas" topic.

Additional query words: XL97 hang hangs hanging hung lock up locks locking locked lockup freeze freezes freezing froze frozen stop stopping stopped won't respond waiting crash crashes crashing crashed quit quitting quits fail fails failing failed break

Keywords          : kberrmsg xlgpf xlformula xlminfo 
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbbug

Last Reviewed: November 6, 1998