Logs

1. Log Viewer

Excelerator keeps a log of Error Messages and Exceptions that might occur whilst in use.

Log Viewer can display these Error Messages and Exceptions which may prove useful in trying to diagnose any issues.

There is the ability to search for a particular Error Message or Exception using the Search box below.

Columns of information may be sorted in ascending or descending order.

Clicking on a row will display additional information relating to the Error/Exception in the Log Item Details section.

Log File Viewer

The logging configuration is contained in the app.config file in the installation directory.

Logging is activated by default. Logging can be enabled/disabled under Customise Display Settings.

Log Viewer - Ribbon Does Not Appear

The Log Viewer also captures the errors that occur when the ribbon does not appear after an installation and can also be accessed by locating the file XMLExcelerator.log.

For a standard installation it can be located through the following path:

C:\Users\UserName\AppData\Roaming\Codis\Excelerator

2. Mandatory Range Missing Exception

Over-riding cause

There is an issue with the Excelerator Template. An Excelerator Template is an Excel file that is designed for use by Excelerator.

Quick Checks

Check that user have a template open - first time users can access default templates that are installed as part of the Excelerator Installation.

Check that user have accessed the correct module (within the Excelerator ribbon) for the template - each Template is module specific.

If user have upgraded Excelerator to the latest version V3 - the template may be of an earlier design - follow to configure earlier templates for V3 to overcome this issue.

Investigate

If these steps have not resolved the issue user will need to so some investigation. The first step when trying to resolve this issue is to check whether the Template has been corrupt. Access the Designer for the relevant module and check that Ranges are ticked.

Reasons

Reason 1 - Using a Template after copying or renaming a worksheet in the template.

Symptom:

The Designer would show no ranges ticked.

Solution:

To fix this problem user would need to go back to an older template.

The correct way to copy a worksheet for Excelerator Copy a worksheet with an Excelerator Template

The correct way to rename a worksheet for Excelerator Rename a worksheet with an Excelerator Template

Reason 2 - When some ranges have been deleted within an existing Template

The Designer shows some ranges ticked.

Solution:

To fix this problem there are two steps.

1. Delete Orphan Ranges
2. Resize Ranges

Reason 3 - A mandatory or required range is not included in the template

Symptom:

The Designer show some ranges ticked - but an unticked range is highlighted in red and the error panel lists a missing range.

Solution:

See Designer

3. Ranges Disappear from Sheet on Multi sheet Excelerator

If the name of the sheet has been changed since design then, use the Designer > Tools > Convert To/Correct To Multiple Sheets option to correct.