Microsoft KB Archive/147888

= MS Excel Crashes Copying Sheet with 3-D References in Formulas =

Article ID: 147888

Article Last Modified on 8/15/2003

-

APPLIES TO


 * Microsoft Excel 95a
 * Microsoft Excel 5.0c
 * Microsoft Excel 5.0a for Macintosh

-



This article was previously published under Q147888



SYMPTOMS
If you copy a worksheet that contains formulas with 3-D references, such as =SUM(Sheet1:Sheet3!A1), Microsoft Excel may generate an irrecoverable error and you will have to quit the program.



CAUSE
This problem occurs when you copy worksheets with formulas that contain 3-D references if the formulas contain #REF! values. The #REF! values within these formulas are usually generated when you make copies of worksheets that are themselves copies of other worksheets containing formulas with 3-D references.



WORKAROUND
To work around this problem, when you make copies of worksheets that contain formulas with 3-D references, always make a copy of the original worksheet and not a copy of a copy. The copy of the original may still contain a #REF! value, but as long as you do not copy a previously copied worksheet, Microsoft Excel should not generate an error.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. The problem was corrected in Microsoft Excel 97 for Windows and Microsoft Excel 98 Macintosh Edition.

Additional query words: 5.0 5.00a 5.00c XL7 XL5 halt freeze stop

Keywords: kbprb KB147888

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.