XL97: Error Inserting or Deleting Rows or Columns After Undo

When you insert or delete a row or column, Microsoft Excel displays one of the following error messages.

Microsoft Windows 95

When you click Details, you receive the following error message:

Microsoft Windows NT

Microsoft Excel then quits.

This problem occurs when the following conditions are true:

• The workbook contains a defined name that refers to a three-dimensional reference. -and-
  
  
• You group items on a worksheet, insert or delete a row or column, reference the defined name, and then click Undo on the Edit menu to undo the insert or delete operation. -and-
  
  
• You insert or delete a column or row that causes a formula that refers to the defined name to recalculate.

To work around this problem, do not insert or delete a column in a workbook that contains a defined name that refers to a 3-D formula when you are in group mode.

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

A 3-D reference is a formula that refers to multiple worksheet in the same workbook. For example, the defined name "Test" can refer to the following formula: This formula adds the values in cell A10 in sheets 1 through 5. If cell A10 contains the value 3 in each sheet, then Test returns the value 15.

You can place a worksheet in group mode by holding SHIFT or CTRL and clicking the sheet tabs you want to group.

For more information about 3-D references, click the Index tab in Microsoft Excel Help, type the following text and then double-click the selected text to go to the "About cell and range references" topic.