Issue:
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.
Cause:
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.
Solution:
Remove any punctuation from the spreadsheet name and worksheet names.