If you use the SUBTOTAL function to calculate the subtotal of a list in an Excel 2003 worksheet that contains a user-defined function, the user-defined function may be calculated more times than expected (898920)


The information in this article applies to:

  • Microsoft Office Excel 2003

SYMPTOMS

You are using a worksheet that contains a user-defined function in Microsoft Office Excel 2003. If you use the SUBTOTAL function to calculate the subtotal of a list of data in the worksheet, the user-defined function may be calculated more times than expected.

CAUSE

This issue may occur if the user-defined function is called more than one time. The user-defined function is called more than one time when the following conditions are true:
  • You used the following procedure to remove the subtotals from the worksheet:
    1. You selected the list that contains the subtotals.
    2. You clicked Subtotals on the Data menu, and then you clicked Remove all.
  • The list of data contains the user-defined function.

WORKAROUND

To work around this issue, follow these steps:
  1. Select the list that contains the user-defined function.
  2. On the Edit menu, click Copy.
  3. On the Insert menu, click Worksheet.
  4. Click Paste Special on the Edit menu.
  5. In the Paste Special dialog box, click Paste Link.
Modification Type:MajorLast Reviewed:5/11/2005
Keywords:kbfunctions kbtshoot kbprb KB898920 kbAudEndUser
©2004 Microsoft Corporation. All rights reserved.