What is the maximum number of data points that can be analyzed using the DFT or IDFT functions?
NumXL is an add-in for MS Excel, so you are bound by the maximum number of rows that Excel supports. For the newer Excel version (2019, the limit is 1,048,576 rows and 16,384 columns.
For more details, please consult Microsoft Office support / Help center:
Excel specifications and limits