XL2001: User Defined Function in Paste Function May Lack Arguments and Return #VALUE (301931)

The information in this article applies to:

Microsoft Excel 2001 for Mac

This article was previously published under Q301931

SYMPTOMS

When you insert a user-defined function in a cell, the cell returns a #VALUE error.

CAUSE

This problem may occur when you click Function on the Insert menu, select User Defined as the Function category, and select a user-defined function in the Function name list.

The Paste Function dialog box may not display any arguments, nor anyplace to type the required arguments. When you click OK, you receive the following message:

This function takes no arguments.

This may not be true, and if you click OK, the result in the cell is a #VALUE error.

RESOLUTION

To resolve this problem, download and install the Microsoft Office 2001 Service Release 1 file. To do so, visit the following Microsoft Web site:

http://www.microsoft.com/mac/downloads.aspx?pid=download&location=/mac/download/office2001/update_905.xml&secid=10&ssid=25&flgnosysreq=True

WORKAROUND

To work around this problem, type the function manually, along with the required arguments. Or, if you inserted the function from the Paste Function dialog box, edit the inserted function in the cell to include the needed arguments.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2001 for Mac Service Release 1.

REFERENCES

For additional information about the Office 2001 Service Release, click the article number below to view the article in the Microsoft Knowledge Base:

294949 OFF2001: Readme for Microsoft Office 2001 for Mac Service Release 1 (SR-1)

Or, visit the Microsoft MacTopia Web site (http://www.microsoft.com/mac) for any additional updates.

Modification Type:	Major	Last Reviewed:	8/4/2006
Keywords:	kbbug kbfix KB301931