XL2002: Argument in the Insert Function Dialog Box Looks Like a Hyperlink but Does Not Work (277589)



The information in this article applies to:

  • Microsoft Excel 2002

This article was previously published under Q277589

SYMPTOMS

When you create a formula that contains a function, a ScreenTip appears to help you type worksheet functions.

When you type a function (such as WEEKDAY or VLOOKUP), and then you rest the mouse on the first argument in the ScreenTip, the pointer becomes a hand, indicating that the argument is a hyperlink. However, when you click the hyperlink, nothing happens.

WORKAROUND

To work around this issue, finish typing your formula. After you complete the formula, double-click the cell containing the formula. When the ScreenTip appears, click any function or argument name in the ScreenTip, and Excel displays information about the function arguments.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Using Function Argument ScreenTip, Excel 2002 displays information about function arguments as you build a new formula. The ScreenTips also provide a quick path to Help. Click the function name within the ScreenTip, and the Help topic appears.

Rest the mouse on an argument within the ScreenTip, and a hyperlink appears. Click the hyperlink, and Excel highlights that specific argument within your formula.

Modification Type:MajorLast Reviewed:3/27/2001
Keywords:kbbug KB277589