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

You are using a worksheet that contains a user-defined function in Microsoft Office Excel 2003 or in Microsoft Office Excel 2007. 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.

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. In Excel 2003, you clicked Subtotals on the Data menu, and then you clicked Remove all.
     
     In Excel 2007, you clickedSubtotal in the Outline group on the Data, and then you clickedRemove all.
• The list of data contains the user-defined function.

To work around this issue in Excel 2003, 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. On the Edit menu, click Paste Special.
5. In the Paste Special dialog box, click Paste Link.

To work around this issue in Excel 2007, follow these steps:

1. Select the list that contains the user-defined function.
2. Click Copy in the Clipboard group on the Home tab.
3. Click the Insert Worksheet tab.
4. Click the arrow on Paste, and then click Paste Special.
5. In the Paste Special dialog box, click Paste Link.