Excel Client:FAQs - Revision history

Admin at 10:00, 3 July 2017

2017-07-03T10:00:23Z

← Older revision		Revision as of 11:00, 3 July 2017
Line 126:		Line 126:
	4) restart your computer		4) restart your computer
	see also [http://support.microsoft.com/kb/329854/en]		see also [http://support.microsoft.com/kb/329854/en]

			==Excel Client with activated option „Require Application Add-ins to be signed by Trusted Publisher“ is deactivated==
			If in Excel the option „Require Application Add-ins to be signed by Trusted Publisher“ is activated and a windows version greater Windows 7 is used, there are problems.
			The CoPlanner Excel add-in is signed, but gets deactivated. This is because Microsoft doesn't sign the mscoree.dll anymore. That problem affects all COM-Addins, not only the CoPlanner Excel add-in.

			The suggested solution from Microsoft is, to deactivate the option „Require Application Add-ins to be signed by Trusted Publisher“.


	__NOEDITSECTION__		__NOEDITSECTION__
	[[category:Excel_Client\|FAQs]]		[[category:Excel_Client\|FAQs]]
	[[de:Excel_Client:FAQs]]		[[de:Excel_Client:FAQs]]

Admin at 08:54, 19 February 2016

2016-02-19T08:54:58Z

← Older revision		Revision as of 09:54, 19 February 2016
Line 37:		Line 37:
	==Installation Excel x64 versions: CoPlanner is missing at the Excel menu==		==Installation Excel x64 versions: CoPlanner is missing at the Excel menu==

	After installing CoPlanner Excel Client for Excel 64 bit not all registy entries will be set. To set all entries you have to execute the file [http://copsupport.coplanner.com/files/wiki/~~CoPlanner_ExcelAddIn_64Bit_94~~.reg (download here)] as administrator.		After installing CoPlanner Excel Client for Excel 64 bit not all registy entries will be set. To set all entries you have to execute the file [http://copsupport.coplanner.com/files/wiki/CoPlanner_ExcelAddIn_64Bit_943.reg (download here)] as administrator.

Admin at 08:54, 19 February 2016

2016-02-19T08:54:51Z

← Older revision		Revision as of 09:54, 19 February 2016
Line 34:		Line 34:
	:*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).		:*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~~.		==Installation Excel x64 versions: CoPlanner is missing at the Excel menu==

			After installing CoPlanner Excel Client for Excel 64 bit not all registy entries will be set. To set all entries you have to execute the file [http://copsupport.coplanner.com/files/wiki/CoPlanner_ExcelAddIn_64Bit_94.reg (download here)] as administrator.

Admin at 07:45, 22 July 2014

2014-07-22T07:45:20Z

← Older revision		Revision as of 08:45, 22 July 2014
Line 115:		Line 115:
	==Hint: "Export not possible"/"no language paket is installed for the configurated language"==		==Hint: "Export not possible"/"no language paket is installed for the configurated language"==

	If the MsgBox "Export not possible"/"no language ~~paket~~ is installed for the configurated language" will be displayed, in MS Office (Excel) the language ~~paket für~~ the display language isn't ~~acivated~~ or installed (see Format->Region and Language).		If the MsgBox "Export not possible"/"no language packet is installed for the configurated language" will be displayed, in MS Office (Excel) the language packet for the display language isn't activated or installed (see Format->Region and Language).

			==Excel Export: Error Message 0x80010001==
			This error is possible if Excel is addressing by another computer f.i. over the network. To solve the error you have to change the registry entry.

			1) click start, execute, enter: regedit
			2) search for the registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLE\EnableDCOM and double click it.
			3) in field value enter Y and commit
			4) restart your computer
			see also [http://support.microsoft.com/kb/329854/en]

	__NOEDITSECTION__		__NOEDITSECTION__
	[[category:Excel_Client\|FAQs]]		[[category:Excel_Client\|FAQs]]
	[[de:Excel_Client:FAQs]]		[[de:Excel_Client:FAQs]]

Admin at 08:21, 10 February 2014

2014-02-10T08:21:00Z

← Older revision		Revision as of 09:21, 10 February 2014
Line 113:		Line 113:
	\|}		\|}

			==Hint: "Export not possible"/"no language paket is installed for the configurated language"==

			If the MsgBox "Export not possible"/"no language paket is installed for the configurated language" will be displayed, in MS Office (Excel) the language paket für the display language isn't acivated or installed (see Format->Region and Language).

Admin at 11:59, 11 December 2013

2013-12-11T11:59:53Z

← Older revision		Revision as of 12:59, 11 December 2013
Line 30:		Line 30:
	:*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).		:*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).

			==The message “The macro ExcelClient.DoCellWrite cannot be executed” appears on refreshing the sheet after log in, or Excel Client functions are not recognized (#Name).==

	==Installation Excel 2010 x64: CoPlanner is missing at the Excel menu		:*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.		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.

Admin at 13:02, 11 November 2013

2013-11-11T13:02:23Z

@@ Line 26: / Line 26: @@
-==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 message “The macro ExcelClient.DeactivateScreenUpdate cannot be executed” appears on refreshing the sheet after log in, or Excel Client functions are not recognized (#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).
@@ Line 40: / Line 40: @@
 Therefor we apply a hotfix. You can find a description [http://support.microsoft.com/kb/963676/en here]. Download the hotfix [http://copsupport.coplanner.com/coplanner/allgemein/NDP20SP2-KB963676-x86.exe here]
-==Activated UAC: The ExcelAddinAcitvator crashes during the Setup==
+==Activated UAC: The ExcelAddinActivator 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.
@@ Line 57: / Line 57: @@
 ==Error Message during the installation, Setup cancels==
-This error message could evoke if the deinstallation of the previous Excel Client wasn't done completely:
+This error message could evoke if the uninstallation of the previous Excel Client wasn't done completely:
 ''Die angekündigte Anwendung wird nicht installiert, da dieser Vorgang möglicherweise nicht sicher ist. Wenden Sie sich an den Administrator, um die Benutzeroberflächenoption für die Installation des Pakets zu ändern. (This advertised application will not be installed because it might be unsafe. Contact your administrator to change the installation user interface option of the package to basic.)''
@@ Line 81: / Line 81: @@
 In addition you have to consider if you have a 32-bit or a 64-bit system.

Admin at 11:01, 11 November 2013

2013-11-11T11:01:13Z

← Older revision		Revision as of 12:01, 11 November 2013
Line 66:		Line 66:
	''msiexec /qb /I CopAddinSetup.msi''		''msiexec /qb /I CopAddinSetup.msi''

	~~<!--~~

	==Formula mode won't be illustrated right==		==Formula mode won't be illustrated right==

	There're among other things two possibilities why the formula mode will be illustrated wrong. On the one hand the Version of the Excel Client isn't correct or the entry OPEN /A „ExcelClient” doesn't exist for the user. This entry has to do manually (HKEY_CURRENT_USER\Software\Microsoft\Office\X.0\Excel\Options)<br>Important: consider the open logic: After OPEN follows OPEN1 OPEN2 etc.		There're among other things two possibilities why the formula mode will be illustrated wrong. On the one hand the Version of the Excel Client isn't correct or the entry OPEN /A „ExcelClient” doesn't exist for the user. This entry has to do manually (HKEY_CURRENT_USER\Software\Microsoft\Office\X.0\Excel\Options)<br>Important: consider the open logic: After OPEN follows OPEN1 OPEN2 etc.




Line 81:		Line 80:
	:* sdtole with Version 7.0.3300.0		:* sdtole with Version 7.0.3300.0

			In addition you have to consider if you have a 32-bit or a 64-bit system.

Admin at 10:58, 11 November 2013

2013-11-11T10:58:07Z

← Older revision		Revision as of 11:58, 11 November 2013
Line 67:		Line 67:

	<!--		<!--
	==Formula mode ~~will~~ be illustrated ~~wrong~~==		==Formula mode won't be illustrated right==

	There're among other things two possibilities why the formula mode will be illustrated wrong.		There're among other things two possibilities why the formula mode will be illustrated wrong. On the one hand the Version of the Excel Client isn't correct or the entry OPEN /A „ExcelClient” doesn't exist for the user. This entry has to do manually (HKEY_CURRENT_USER\Software\Microsoft\Office\X.0\Excel\Options)<br>Important: consider the open logic: After OPEN follows OPEN1 OPEN2 etc.
	~~First~~ check the version of 4 specific Excel Client files.



			To check the version you have to review 4 specific Excel Client files:

	:* Microsoft.Office.Interop.Excel with Version 10.0.4504.0		:* Microsoft.Office.Interop.Excel with Version 10.0.4504.0
Line 77:		Line 81:
	:* sdtole with Version 7.0.3300.0		:* sdtole with Version 7.0.3300.0

	Second, check the Open enteries at the Registry.CurrentUser if there is an entry or if the entry is set on /A “ExcelClient”. If not 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).
	~~-->~~

Admin at 10:45, 11 November 2013

2013-11-11T10:45:03Z

← Older revision		Revision as of 11:45, 11 November 2013
Line 36:		Line 36:


	==Excel crashes in ~~conbination~~ with the MicroStrategy AddIn==		==Excel crashes in combination with the MicroStrategy AddIn==

	Therefor we apply a hotfix. You can find a description [http://support.microsoft.com/kb/963676/en here]. Download the hotfix [http://copsupport.coplanner.com/coplanner/allgemein/NDP20SP2-KB963676-x86.exe here]		Therefor we apply a hotfix. You can find a description [http://support.microsoft.com/kb/963676/en here]. Download the hotfix [http://copsupport.coplanner.com/coplanner/allgemein/NDP20SP2-KB963676-x86.exe here]
Line 49:		Line 49:

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


	[[Image:EC_ExcelExportErrorCode.jpg\|thumb\|center\|Excel Client, Language Settings]]		[[Image:EC_ExcelExportErrorCode.jpg\|thumb\|center\|Excel Client, Language Settings]]



			==Error Message during the installation, Setup cancels==

			This error message could evoke if the deinstallation of the previous Excel Client wasn't done completely:

			''Die angekündigte Anwendung wird nicht installiert, da dieser Vorgang möglicherweise nicht sicher ist. Wenden Sie sich an den Administrator, um die Benutzeroberflächenoption für die Installation des Pakets zu ändern. (This advertised application will not be installed because it might be unsafe. Contact your administrator to change the installation user interface option of the package to basic.)''

			In this case you have to call up the msi file over the command shell with the command stated below


			''msiexec /qb /I CopAddinSetup.msi''

	<!--		<!--