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.