The information in this article applies to:
SYMPTOMSWhen you insert or delete a row or column, Microsoft Excel displays one of the following error messages. Microsoft Windows 95When you click Details, you receive the following error message:
Microsoft Windows NTMicrosoft Excel then quits. CAUSE
This problem occurs when the following conditions are true:
-and- -and- WORKAROUNDTo 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. STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. MORE INFORMATIONA 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. REFERENCESFor more information about 3-D references, click the Index tab in Microsoft Excel Help, type the following text 3-d referencesand then double-click the selected text to go to the "About cell and range references" topic. Additional query words: XL97 8.00 3d access violation
Keywords : xlformula |
Last Reviewed: November 4, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |