Excel: Opening 3-D Surface Chart Causes Divide by Zero Error

Last reviewed: April 17, 1996
Article ID: Q88002
The information in this article applies to:
  • Microsoft Excel for Windows, version 4.0, 4.0a
  • Microsoft Windows operating system, version 3.0 and 3.1

SYMPTOMS

In Microsoft Excel for Windows, when you open a 3-D surface chart that has a legend attached to the top or bottom, you will get the following error message:

   Divide by Zero or Overflow Error

You will get this same error message when you open a workbook file that contains this type of chart document.

If you are running Microsoft Excel with the Microsoft Windows operating system version 3.1, Microsoft Excel will close. When this happens, you should exit Windows and restart your computer.

With Microsoft Windows version 3.0, you will receive an unrecoverable application error (UAE) and Windows will hang, making it necessary to restart your computer.

WORKAROUND

To open a document as a 3-D surface chart, you must recreate the chart and attach the legend to the left or right.

Note: This problem occurs only with Microsoft Excel for Windows.

Transferring the files between the Macintosh and PC formats requires a utility program such as Apple File Exchange.

STATUS

Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed above. This problem was corrected in version 5.0 of Microsoft Excel for Windows.


KBCategory: kbusage
KBSubcategory:

Additional reference words: 4.0 4.00 lock up freeze crash fail UAE
graph



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 17, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.