When hotlinking to a spreadsheet, the figures pull through fine. But when exiting out of Forecast 5 and coming back in, the hotlink is no longer holding.
This can be due to punctuation marks, e.g. ' (apostrophe), , (comma), etc. Because Forecast 5 uses SQL Server to store the database, these punctuation marks are frequently used when writing code, therefore any additional marks can cause issues.
Remove any punctuation from the spreadsheet name and worksheet names.