XL: Page Fault or Type 2 Error Using Highlight Changes in Chart

• Microsoft Excel 97 for Windows
• Microsoft Excel 98 Macintosh Edition

SYMPTOMS

In Microsoft Excel 97 for Windows, you may receive the following error message when you click OK in the Highlight Changes dialog box:

   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:302de3b2.

   The application "Microsoft Excel" has unexpectedly quit, because
   an error of type 2 occurred.

   You should save your work in other open applications and restart
   the computer.

CAUSE

This problem occurs when the following conditions are true:

• When a chart sheet is active, you point to Track Changes on the Tools menu and click Highlight Changes.

      -and-
  

• In the Highlight Changes dialog box, you click to select the "Track changes while editing" check box.

      -and-
  

• You click to select the Where check box, click a worksheet tab, hold down the SHIFT key, and then click another worksheet tab.

      -and-
  

• You select a range of cells so that the Where reference box contains a reference that is similar to the following:

        'Sheet2:Sheet3'!$B$5:$D$10
  

      -and-
  

• You click OK.

NOTE: This problem does not occur if a worksheet is active when you point to Track Changes on the Tools menu and click Highlight Changes. Instead, you receive the following error message:

   Reference is not valid.

RESOLUTION

To resolve this problem, do not click Highlight Changes on the Tools menu when a chart sheet is active.

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.

MORE INFORMATION

In the versions of Microsoft Excel listed at the beginning of this article, you can use the Highlight Changes dialog box to highlight changes made to cells in a shared workbook. These changes include moved or pasted contents and inserted or removed columns or rows. When you use the Highlight Changes dialog box, a blue outline and a marker appear around any cell with the contents that have been changed.

The problem described in the "Symptoms" section in this article occurs only if you select two or more worksheets in which to highlight changes, and the active sheet is a chart sheet.