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 > Options > Formulas > Working with Formulas.

You may need to relink the hotlink.

• Related Articles

• 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'. ...

• 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 ...

• Hotlink: P&L Report Still Reflecting Old Figures

  Issue: When using Hot Links in a forecast, you have updated the figures in the spreadsheet, refreshed the link and the record is correct but when you run the P &L report the old figures are still appearing.   Solution: Remove the Hot Link for each ...

• 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 ...

• Paste from Excel - The figures will not paste

  Issue: I have copied the figures to my clipboard in Excel, right-clicked on the Set All box and selected Paste from Excel but nothing happens: Solution: Ensure that the figures in excel are NOT currency. Change to General, Number or Text.