Hotlink: P&L Report Still Reflecting Old Figures

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 record affected and re-add. Then check the report.



    • Related Articles

    • One Touch Reporting: The report is showing old figures.

      Question: When running my One Touch Report, it is showing old figures or dates in the reports exported. Answer:  One Touch Reporting saves the exported report into your Documents folder, using the name of your forecast. If you have run the OTR report ...

    • P&L Reports - Unable to view reports

      Issue: When trying to run the P&L report, the report will not display. All other reports are working fine. Solution: This is caused by the use of SQL Server 2008, which is not supported by Forecast 5. Please upgrade to a supported version of SQL, ...

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