XL97: Errors After Copying Worksheet with Auditing Arrows

ID: Q168564

The information in this article applies to:

Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel 97, the following problems may occur:

When you delete a worksheet, you 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 any of the following:

      EXCEL caused an invalid page fault in module KERNEL32.DLL at
      0137:bff798fc.

      EXCEL caused an invalid page fault in module EXCEL.EXE at
      0137:3028c56f.

      EXCEL caused an invalid page fault in module <unknown> at
      0000:7c651f00.

When you click Close, Microsoft Excel 97 quits.

If you click the Tools menu, point to Auditing, and click Remove All Arrows, you receive an error message in the previous symptom.
If you click an auditing arrow, you may receive the Illegal Operation error message described in this article.
If you click Details, you receive the following error message:
```
      EXCEL caused an invalid page fault in module MSO97.DLL at
      0137:306f3fed.
```

When you save a workbook, you receive the following error message:

      This workbook contains features that are not supported by the file
      format that you selected. To avoid the possible loss of formatting
      or information, be sure to save a copy in the most recent Microsoft
      Excel Workbook format.

Note that you receive this message even if you are saving the workbook in the Microsoft Excel Workbook format.

CAUSE

These problems occur when the following conditions are true:

You copy a worksheet that contains auditing arrows in the same workbook or move this worksheet to another workbook.
```
    -and-
```
You attempt to delete the new worksheet, to remove auditing arrows from the new worksheet, to select an auditing arrow, or to save the workbook that contains the worksheet.

Auditing arrows in Microsoft Excel 97 are not designed to be copied. As a result, if you copy a worksheet that contains auditing arrows, the arrows on the new worksheet may become unstable. This may cause problems if you attempt to delete the new worksheet, save the workbook, select an auditing arrow, or remove the auditing arrows from the new worksheet.

RESOLUTION

To prevent these problems from occurring, remove all auditing arrows in the worksheet before you copy it. To remove the arrows, do the following:

1. Click the worksheet that contains the auditing arrows.

2. On the Tools menu, point to Auditing, and then click Remove All Arrows.

After you copy the worksheet, you can make the auditing arrows available.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

In Microsoft Excel 97, you can use auditing arrows to trace dependents, precedents, and errors. To use auditing arrows, do the following:

1. Select the cell you want to audit.

2. On the Tools menu, point to Auditing, and then click Trace

   Precedents, Trace Dependents, or Trace Error, as appropriate.

If you click Show Auditing Toolbar, you can use the tools on the Auditing toolbar to audit cells.

Additional query words: XL97 snafaq

Keywords          : kberrmsg xlloadsave xlui xlgpf 
Platform          : WINDOWS
Issue type        : kbprb

Last Reviewed: February 3, 1999