Issue / Error Message:
When trying to import the record list from excel or hotlink to a spreadsheet, the error message below or similar occurs:
Incorrect syntax near 's'
Unclosed quotation mark after the character string 'WHERE[1d]=15035'.
This is caused if there are any record names with ' (quotes) or " (double quotes) or in the spreadsheet name if hotlinking.
Open the import file in excel and remove any ' (quote) or " (double quote) in the record names.
Then reimport the record list into Forecast 5 or hotlink again.