XL5: GPF Opening Worksheet With Reference to Named 3-D Range

ID: Q109572


The information in this article applies to:
  • Microsoft Excel for Windows, version 5.0


SYMPTOMS

In Microsoft Excel, you receive a general protection (GP) fault when you open a worksheet that has been saved in the Microsoft Excel 3.0 Worksheet or 4.0 Worksheet format if the worksheet contains a cell that refers to a named 3-D range on another workbook and follows a cell that refers to a cell that is included in that named 3-D range.

WORKAROUNDS

To work around this problem, do any of the following:

  • If you have already saved a worksheet in the situation described above, open the file in Microsoft Word, or another application that can open Microsoft Excel 3.0 and 4.0 worksheets. Save the file in a text format and open the file in Microsoft Excel. Formatting and defined names may be lost, but you can recover your text with this method.


  • -or-

  • Enter the reference to the named 3-D range in a cell above or to the left of the cell that refers to the cell contained in the 3-D range.


  • -or-

  • Avoid referring to named 3-D ranges and cells contained in that range when saving a worksheet in Microsoft Excel 3.0 Worksheet or 4.0 Worksheet format. You can reference one or the other but not both.



MORE INFORMATION

A 3-D reference is one that spans two or more sheets in a workbook. For example, to sum the range A1:B2 on Sheet1 and Sheet2 in a workbook, use the following formula:


   =SUM(Sheet1:Sheet2!$A$1:$B$2) 
If you save a worksheet that contains 3-D a reference to the workbook containing it in Microsoft Excel 3.0 or 4.0 Worksheet format, you receive the following error message
Cannot write record.

Continue reporting each error?
followed by:
Total number of file errors: 1


STATUS

This problem was corrected in Microsoft Excel for Windows 95, version 7.0.


REFERENCES

For more information about Defining A Name With A 3-D Reference, choose the Search button in Help and type:

3-D references

Additional query words:

Keywords :
Version : WINDOWS:5.0
Platform : WINDOWS
Issue type :


Last Reviewed: October 5, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.