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 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 (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).

==Installation Excel 2010 x64: CoPlanner is missing at the Excel menu

After installing CoPlanner 9.1x for Excel 64 bit not all registy entries will be set. To set all entries you have to execute 3 batch files as Administrator from the archive Media:Excel_x64.zip. Beginning with version 9.2 HF 1.6 the CoPlanner will be installed correctly also for 64 bit systems.

Excel crashes in conbination with the MicroStrategy AddIn

Therefor we apply a hotfix. You can find a description here. Download the hotfix here

Activated UAC: The ExcelAddinAcitvator crashes during the Setup

If the UAC is activated it isn't sufficient to execute the install.bat as Administrator. In this case you must start a command shell with administrator rights. Then you call up the file install.bat out of the command shell.

Excel Export: Errorcode 0x80028018

If the client computer runs the English version of Excel and the locale for the current user is configured for a language other than English, Excel will try to locate the language pack for the configured language. If the language pack is not found, the error is reported.

You’ll have to install the configured language pack for Excel that matches your computer’s language setting.

Error creating thumbnail: File missing

Excel Client, Language Settings