Hotlinks not holding

Hotlinks not holding

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.


    • Related Articles

    • Update the config file - point Forecast 5 to a new server or database.

      If you have a network license and you wish to store the Forecast 5 database on a server, you will need to update the config file to point to the correct server and database. On the server, go to this path: C:\ProgramData\Forecast 5 Ltd Edit the file ...

    • Using bank accounts for shareholders payments and crediting to current account

      How to set up shareholders payments and credit to current account Set up a P&L Cost as separately invoiced cost and call it “shareholders salaries” Create a bank account called “Drawings” Create an other debtor/creditor  account (Other assets and ...

    • Using Reset to No Actual’s

      The Reset to No Actuals feature is designed to make the next year budget easier. This works by saving your actuals as the budget figures to then allow to you extend the budget into next year using these figures as the basis for extend and amend. ...

    • How to change the default currency for a forecast

      Issue: You want to create a forecast for a country not available on our list, e.g. South Africa Solution: Update the default currency to the correct Name, Symbol and TLA. 1. Choose any country, e.g. USD 2. Fill out the details and click Update ...

    • Using Forecast Status

      We have recently introduced a forecast status for Admin Pack users. This allows the owner of a forecast to define the status of a forecast;  Editable = Anything can be changed in the forecast.  Budget Entry = Only numbers can be entered (settings and ...