XL: GP Fault When Saving File Containing 3-D Reference
ID: Q121391
|
The information in this article applies to:
-
Microsoft Excel for Windows, versions 5.0, 5.0c
-
Microsoft Excel for the Macintosh, versions 5.0, 5.0a
-
Microsoft Excel for Windows 95, versions 7.0, 7.0a
SYMPTOMS
In Microsoft Excel 5.0, when you save a workbook (DEP.XLS, for example)
that contains a 3-D reference to a range in another workbook (SUP.XLS, for
example), you may receive a general protection (GP) fault (Windows) or a
system error type 11 (Macintosh).
CAUSE
This problem will occur if all of the following conditions are true:
- SUP.XLS is open when you try to save DEP.XLS.
-and-
- The worksheets in SUP.XLS referred to by the formula in DEP.XLS are
preceded by one or more Visual Basic, Applications Edition, modules.
-and-
- A formula in DEP.XLS refers to a 3-D range in SUP.XLS.
WORKAROUNDS
To work around this problem, do any one of the following:
- Make sure SUP.XLS is not open at the time you try to save DEP.XLS.
The error will not occur if SUP.XLS is not open.
-or-
- Move all Visual Basic modules in SUP.XLS after the worksheets in
SUP.XLS. For example, instead of using a sheet tab order like this
Module1, Sheet1, Sheet2, Sheet3
use a sheet tab order that resembles the following:
Sheet1, Sheet2, Sheet3, Module1
-or-
- Do the following to turn off the Save External Links Values option for
the dependent workbook:
- With the dependent workbook active, choose Options from the Tools
menu.
- Select the Calculation tab.
- Clear the Save External Link Values check box.
- Choose OK to accept the change.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
MORE INFORMATION
This error occurs because of the way that Microsoft Excel saves workbooks.
When you save a workbook (DEP.XLS) that is dependent on another workbook
(SUP.XLS), and if the dependent workbook contains 3-D links to the
supporting workbook, Microsoft Excel cannot properly establish the link
information if the first worksheet in the 3-D reference is preceded by a
Visual Basic module. This causes a GP fault to occur.
To avoid this problem, use any of the three workarounds shown above.
Note that this problem does not occur with chart sheets, MS Excel 4.0 Macro
sheets, or dialog sheets.
Additional query words:
5.00c
Keywords :
Version : WINDOWS: 5.0, 5.0c, 7.0, 7.0a; MACINTOSH: 5.0, 5.0a
Platform : MACINTOSH WINDOWS
Issue type :
|