Restart Tab

Restart control

File to restart after

If you need to restart a job to recover from an error, specify the restart filename in this box. All files prior to AND INCLUDING this file will be skipped.

Microsoft Excel Control

The following options are used for controlling Microsoft Excel - in particular, how Microsoft Excel errors are handed. This settings should be left alone unless you know what you are doing!

Version of Microsoft Excel to invoke (use ONLY with multiple Microsoft Excel installations)

If you have more than one version of Microsoft Excel installed, you can use this field to determine which version ExcelPipe interacts with.

If you only have one version of Microsoft Excel installed, leave this set to the 'Automatic' setting.

Restart Microsoft Excel after this many documents

Microsoft Excel's performance and reliability can be improved (especially for large documents, and large numbers of documents) if it is restarted periodically.

A value of 0 disables this option, 100 documents is a useful default.

Restart Microsoft Excel automatically if unresponsive for this many seconds

Microsoft Excel can sometimes get stuck when opening a document, for example, if it detects that an error occurred last time it opened a document, it will ask for confirmation. This kind of message can interrupt ExcelPipe's processing, so you can force ExcelPipe to restart Microsoft Excel after a given number of seconds of inactivity.

A value of 0 disables this option, 30 seconds is a useful default.

Location of EXCEL.EXE (to restart from catastrophic failures)

Sometimes when Microsoft Excel is restarted it corrupts its own settings in the System Registry, making it impossible to restart using normal methods. By specifying the path to Microsoft Excel, you can get ExcelPipe to attempt to restart Microsoft Excel directly. Use the browse button to locate EXCEL.EXE, possibly in C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE.