The information in this article applies to:
SYMPTOMSIn Microsoft Excel, when you use the Fourier Analysis tool, provided in the Analysis ToolPak add-in, to transform data in a worksheet, and you then use the Fourier Analysis tool again and you use values previously returned by this function as the new input range values, you receive the following error message: This behavior does not occur in Microsoft Excel version 4.0. CAUSEThis behavior occurs because any non-imaginary number that is returned by the Fourier Analysis tool is formatted as a text value instead of number value. Because the Input Range value used in the Fourier Analysis tool must be formatted as a number, the error message appears when you use this returned value as an input value in the Fourier Analysis tool. WORKAROUNDSTo avoid receiving this error message, do either of the following before using the Fourier Analysis tool using an input data range that has been returned by the Fourier Analysis tool:
-or- REFERENCESFor more information about Fourier Analysis, choose the Search button in Help and type: Fourier Analysis Tool Additional query words: 5.00c err msg addin addins toolpack tool pak pack
Keywords : kbprg |
Last Reviewed: October 22, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |