Microsoft KB Archive/114572

{|
 * width="100%"|

XL5: FVSCHEDULE Function Causes GP Fault in ANALYSIS.XLL

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, version 5.0

-

SYMPTOMS
In Microsoft Excel, if you use the FVSCHEDULE function on a worksheet that already contains the FVSCHEDULE function, you receive a general protection (GP) fault in ANALYSIS.XLL.

CAUSE
This error message appears if you have already used FVSCHEDULE on the worksheet when you enter the second instance of FVSCHEDULE, and you then reference an empty cell for either the principal argument or the schedule argument.

Note that this problem occurs whether you insert the FVSCHEDULE function by using the Paste command, the Fill command, the fill handle, or the Function Wizard.

WORKAROUND
To avoid receiving a GP fault when you use the FVSCHEDULE function on a worksheet, do either of the following to ensure that the Principal and Schedule arguments do not reference empty cells:


 * Enter a numeric value for the argument.
 * Reference a cell that contains data.

STATUS
Microsoft has confirmed this to be a problem in the Microsoft 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.

MORE INFORMATION
The FVSCHEDULE worksheet function is available when you load the Analysis ToolPak (ANALYSIS.XLL) add-in file.

Additional query words: gpf add-in tool pack toolpack

Keywords :

Version : 5.00

Platform : WINDOWS

Issue type :

Technology :