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.

    • Related Articles

    • Hotlink: Figures not pulling through

      Issue: After adding my hotlink and selecting the row of figures, the figures are not pulling through to the record. Solution: In the Excel spreadsheet you are hotlinking to, check that the R1C1 reference style is not ticked. This is found in Files > ...

    • HotLink Exception: Exception of type 'Forecast5.Model.HotlinkException' was thrown.

      Issue: When opening your forecast, you get the following error: HotLink Exception: Exception of type 'Forecast5.Model.HotlinkException' was thrown.: 'location and name of the hotlink file.xlsx".  Hot Link error found in 'Record Name'. ...

    • How To: Hotlink from other forecasts

      What is Hotlink from other forecasts? Hotlink from other forecasts allows you to pull data in from a record in another forecast. How to use: Prerequisites To use hotlinks from one forecast to another, they must have the same start date, so the data ...

    • Record List Import - Wages importing negative

      Issue: When using the Record List import to bring in your data from Excel, the wages records are importing as negative values. Solution: Until a permanent solution is found, follow the steps below: 1. Enter 0 in the set all box of each wages record. ...

    • Hotlink Error: "Exception of Type 'Forecast5.Model.HotlinkException' was thrown."

      Issue: When trying to setup a second Hotlink record, you receive this error: Exception of type 'Forecast5.Model.HotlinkException' was thrown.: 'location and name of the hotlink file.xlsx 2". Hot Link error found in 'Record Name'. Do you want to ...