XL98: Crash Pasting Input Cells for a Data Table (178855)



The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition

This article was previously published under Q178855

SYMPTOMS

When you paste information in Microsoft Excel 98 Macintosh Edition, error messages similar to the following may appear.
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.

-or-

Sorry, a system error occurred.
"Microsoft Excel"
error type 11

CAUSE

This problem may occur when you do the following:
  • You select cells that are being used as row input and column input cells in a two-variable data table and click Cut on the Edit menu. -and-

  • You paste the cut cells into a different worksheet.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 98 Macintosh Edition.

MORE INFORMATION

The row and column input cell must refer to a cell on the active worksheet outside of the table range.

For additional information, please see the following article in the Microsoft Knowledge Base:

95811 Excel Err Msg: "Input Cell Reference Is Not Valid"

REFERENCES

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

data tables, creating

and then double-click the selected text to go to the "Create a two-variable data table" topic.

Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbbug KB178855