XL: Custom Function in the Wrong Category in Function Wizard

Last reviewed: February 2, 1998
Article ID: Q141825
The information in this article applies to:
  • Microsoft Excel for Windows 95, version 7.0
  • Microsoft Excel for Windows NT, version 5.0
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SYMPTOMS

In Microsoft Excel, when you use the Function Wizard, a custom function may appear in a category that is different from the category assigned to that custom function. This problem will occur only if you have assigned a function to a category that you created.

CAUSE

The built-in categories appear at the beginning of the category list in the Function Wizard. The order for these built-in categories does not change; instead, the custom categories are added to the end of the category list.

When you assign a function to a specific category, Microsoft Excel actually assigns the function a number that represents that category (the categories are numbered as they appear in the Function Wizard). When you open a new workbook in Microsoft Excel, any custom categories contained in that book are simply appended to the current list of categories. Thus, the order in which workbooks are opened can effect the order that custom categories appear in the Function Wizard.

WORKAROUND

To work around this problem, assign the function to one of the built-in categories since the order for these categories will not change.

STATUS

Microsoft has confirmed this to be a problem in the products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

For additional information, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q137526
   TITLE     : How to Add a New Function Category to the Function
               Category List


Additional query words: 5.00 5.00a 5.00c 7.00 user-defined
Version : WINDOWS:5.0,5.0c,7.0; MACINTOSH:5.00,5.00a
Platform : MACINTOSH WINDOWS
Issue type : kbbug
Solution Type : kbworkaround


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: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.