While using NumXL for forecasting using single double or triple exponential smoothing we observed that it is returning error value (#NUM!)
as an example if for previous 24 months the data was equal to 1 then forecast for the 25th month is returned as #NUM! using exponential smoothing. The issue is not just limited to the above example.
However the error is not reported for all calculations and only some of them for the analysis that we are carrying out.
We have checked the optimization option in smoothing.