One Touch Reporting - An error occured while using the template

One Touch Reporting - An error occured while using the template


When trying to create a OTR report from Forecast 5, you are receiving the error below:



This can be due to a number of reasons:

1. The excel template you are trying to use is already open.

2. The forecast name contains characters that are invalid for an excel name.

3. You do not have permissions to write to the Documents path


Reason 1: Excel Is Open

1. Close all open excel templates and check no processes are running in the background. 

2. Try run the report again.

Reason 2: Invalid Characters

1. Check the forecast name does not contain any invalid characters, e.g. \ - / ? !

2. If you are unsure, create a new excel sheet, click Save As, then copy the forecast name as the excel name.

3. If you can save, then move to reason 3. If you can't save, remove any characters.

Reason 3: Permissions

2. In your Windows Explorer, Right-click on Documents and click on Properties:

2. Click on the Security tab and click Edit. Then, in the next window, click Add..

3. In the white box, type Everyone. Click Check Names and then Ok.

4. Click on Everyone, add Full Control to the Allow column, then click Ok.

4. Run the report again.

    • Related Articles

    • One Touch Reporting: The report is showing old figures.

      Question: When running my One Touch Report, it is showing old figures or dates in the reports exported. Answer:  One Touch Reporting saves the exported report into your Documents folder, using the name of your forecast. If you have run the OTR report ...
    • How To: Use One Touch Reporting (OTR)

      Try the template (at the bottom of this page) to see how it works. Overview The One Touch Reporting (OTR) feature is designed to reduce the amount of time taken to produce final and quality reporting. Using the One Touch button, you can drop your ...
    • Moving Forecast 5 from one machine to another.

      If you have a Single Computer License and you change computers, there are two ways to do keep your forecasts: Method 1: For those using Localdb - Moving the Data Folder On your old PC, go to C:\ProgramData\Forecast 5 Ltd - please note this is ...
    • SQLException: A network-related or instance-specific error... [Error: 52]

      Issue: Forecast 5 cannot continue because of an exception occured: SqlException Solution:   This error is generally caused because the Forecast 5 cannot find the SQL Server you are trying to connect to. Please check that your computer can see the SQL ...
    • GST/VAT Rate Error: TargetInvocationException

      Issue / Error Message: When opening a forecast, the following error occurs:   TargetInvocationException Exception has been thrown by the target of an invocation. NullReferenceException Object reference not set to an instance of an object.    at ...