Hotlink: Figures not pulling through

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.