Back Forward Troubleshooting Excel

 Troubleshooting topics

This note describes symptoms and remedies for Microsoft Excel when used with Process Commander.

1. Symptom: LaunchManager error

When starting the Data Table editor, the following Windows alert appears:

Warning: Method: bExcelAutoGenLaunchManagerShell .File Not found

Action

An ActiveX control on the workstation is incompatible with the current version of Process Commander.

  1. Exit from Process Commander and Excel, if in use
  2. Open the directory C:/Windows/Downloaded Program Files (for XP) or C:/WINNT/Downloaded Program Files (for Windows 2000)
  3. Delete the ActiveX control named prImportManagerOCX.
  4. Repeat the Process Commander operation that produced the error. Windows downloads a fresh version of the ActiveX control.

Symptom: Cell contains ########

After a list view or summary view report is exported to Excel, a cell in the Excel spreadsheet contains ###### rather than the report data for that row and column.

Action

The length of the property exceeds the 1023-character limit on cell size of Excel 2003. As a workaround:

  1. Create a new column in Excel (for example, column H)
  2. Unlock the column, if it is locked. (Use the Format > Cells > Protection menu.)
  3. Enter the formula =LEFT(G2, 1023) in the new cell H2, where G is the column containing the ##### characters. This creates a shorter text value that Excel can display.
  4. Copy the formula down the column
  5. Select the entire column. Copy the column, then Paste Special > Values.
  6. Delete the original column
Related topics Understanding ActiveX controls and Process Commander

UpTroubleshooting