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. SR-4274

  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