Excel Client:FAQs

Under certain conditions, the Excel Client can produce known errors. The following erroneous behaviours are known and can be solved as described here:

After installing, and sometimes after successful initial use of the program, the item CoPlanner X.X will be missing from the Add-Ins tab.

• Setup must be installed for every user form whom the Excel Client is to be available (see Chapter 2, Installation). (Admin => setup. exe, User => CopAddinSetup. msi).
• The file Excel.exe.config belonging to the previous version of the Excel Client must be removed from the folder containing the file Excel.exe.
• The macro security level in Excel must be Low or Medium (Tools => Macro => Security).
• The Excel Client was disabled for some reason (Office Button, Excel Options, Add-Ins, Manage, Disabled items).
• The LoadBehavior flag in the Registry is not set to 3. This flag can be found under HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\AddIns\ExcelClient. There are several possible reasons for this:
• The user does not have read privileges in the install folder;
• An older version of the client was not successfully uninstalled;
• The .Net Batch (See Chapter 1, Installation) was not successfully installed.
• An older version was not properly uninstalled. Verify the Registry entry for HKEY_CLASSES_ROOT\CLSID\{3F1EF353-FFE4-4C60-95C2-FA39DAFE1953}\InprocServer32. This entry must contain a Registry key that is identical to the version number of the version of the CoPlanner Excel Client that you wish to run. Please ensure that only ONE Registry key containing a version number is present.

Connection to the CoPlanner server cannot be established.

• Check your access details in the file ClientConfig.xml ([Path to Excel Client]\ClientConfig.xml) (Server/Port/TcpFormatter)
• There is a version conflict between the client and the server (compare CoPlanner X.X => Info => Version with the version number of the CoPlanner server).

No response when clicking on CoPlanner X.X menu items.

• The country setting must correspond to the language of the version of Excel that is installed on your computer. For example, if you have an English operating system and an English version of Excel, then the country must be set to EN.

The message “The macro ExcelClient.DeactivateScreenUpdate cannot be executed” appears on refreshing the sheet after login, or Excel Client functions are not recognised (#Name).

• The entry for AddIn usage is no longer present in the Excel arithmetic unit.

Use the Registry Editor (Regedit) to edit the entry OPEN /A “ExcelClient” for the user (HKEY_CURRENT_USER\Software\Microsoft\Office\X.0\Excel\Options).