Hotlink: Index was out of range. It must be non-negative and less than the size of the collection.

Hotlink: Index was out of range. It must be non-negative and less than the size of the collection.

issue:

I receive this error when trying to hotlink a file:




Cause:
This is likely due to the excel spreadsheet being saved as a .xls file which is not compatible with Forecast 5 as it is too old.
Note: Microsoft Excel 97-2003




Solution:
Save the file as an .xlsx file and re-add to Forecast 5.