Microsoft KB Archive/101433: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 40: | Line 40: | ||
<br /> | <br /> | ||
<br /> | <br /> | ||
THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED | 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. | ||
</blockquote> | </blockquote> | ||
<span>Last reviewed: September 12, 1996</span><br /> | <span>Last reviewed: September 12, 1996</span><br /> | ||
[[../cpyright|©1997 Microsoft Corporation. All rights reserved. Legal Notices]].<br /> | [[../cpyright|©1997 Microsoft Corporation. All rights reserved. Legal Notices]].<br /> | ||
|} | |} |
Latest revision as of 09:32, 20 July 2020
Microsoft Knowledge Base
Can't Define Name for Formula with OFFSET() and INDIRECT()
Last reviewed: September 12, 1996
Article ID: Q101433
The information in this article applies to:
- Microsoft Excel for Windows, versions 4.0,4.0a
- Microsoft Excel for the Macintosh, version 4.0
SYMPTOMS
In Microsoft Excel, if you define a name that refers to a formula that contains the INDIRECT() and OFFSET() functions, a general protection (GP) fault may occur. If you are using Microsoft Excel for the Macintosh, your machine may hang and no error message will be displayed. At this point you will have to restart the machine.
STATUS
Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed above. This problem was corrected in Microsoft Excel version 5.0 for Windows.
MORE INFORMATION
This error occurs when you define a name that refers to a reference as in the following example:
=INDIRECT(OFFSET(J10,-6,0):OFFSET(J10,-1,0))
This formula is not unique. Using other cell references or values within the OFFSET() function may also produce a GP fault, often at an address in the 0033:xxxx range.
KBCategory: kbfixlist Last reviewed: September 12, 1996 |