If Excel does not launch from the Planning Workbench in Integrated Operational Planning, try the following:
In Excel, select Tools, then Macros, and then Security. Switch to Trusted Publishers and ensure that Trust all installed add-ins and templates is selected.
In Excel 2009 only, Select Help, and then About Microsoft Excel. Select Disabled Items for Ambassador. If listed, re-enable it again.
Check for the following registry entry:
HKEY_CLASSES_ROOT\Excel.Application
If it is missing, copy the version from:
HKEY_CLASSES_ROOT\Excel.Application.9
Uninstall Ambassador. (You may have to close all Microsoft Office applications including Outlook and Internet Explorer.) In Internet Explorer, select Tools, and then Internet Options; then, delete cookies and files.
Complete the following steps:
Uninstall Ambassador. (You may have to close all Microsoft Office applications including Outlook and Internet Explorer.)
In Internet Explorer, select Tools, and then Internet Options; then, delete cookies and files.
Remove the cache folder under Documents and Settings\your_login\Local Settings\Temp\interlace.
Verify that your registry entry, HKEY_CURRENT_USER\Software, does not list an interlace entry. If the entry for interlace exists, remove it.
In the registry, search for and remove the following keywords (in the Find dialog box, make sure to select keys, values, and data):
anteros
ambassador
{Anteros CLSID} - current: 79B589EC-406A-45a8-88C8-C07A3C7101DB
Reboot your computer.
Verify the following registry entries as used by Ambassador:
The following keys are used for creating important objects. If any are missing, the result is usually fatal.
HKEY_CLASSES_ROOT\CLSID{2933BF90-7B36-11d2-B20E-00C04F983E60}//XML DOM object
HKEY_CLASSES_ROOT\CLSID{ED8C108E-4349-11D2-91A4-00C04F7969E8}//XML HTTP Request
HKEY_CLASSES_ROOT\CLSID{8856F961-340A-11D0-A96B-00C04FD705A2}//the MS WebBrowser control
HKEY_CLASSES_ROOT\CLSID{0E59F1D5-1FBE-11D0-8FF2-00A0D10038BC}//the MS ScriptControl
Ambassador reads configuration information from the following paths:
HKEY_CLASSES_ROOT\InternetExplorer.Application\ HKEY_CLASSES_ROOT\Excel.Application\ HKEY_CLASSES_ROOT\MSProject.Application\ HKEY_CLASSES_ROOT\Outlook.Application\ HKEY_CLASSES_ROOT\PowerPoint.Application\ HKEY_CLASSES_ROOT\Visio.Application\ HKEY_CLASSES_ROOT\Word.Application\ HKEY_CLASSES_ROOT\Word.Document\ HKEY_CLASSES_ROOT\MSXML.DOMDocument\ HKEY_CLASSES_ROOT\Msxml2.DOMDocument\ HKEY_CLASSES_ROOT\MSXML2.DOMDocument.2.6\ HKEY_CLASSES_ROOT\Msxml2.DOMDocument.3.0\ HKEY_CLASSES_ROOT\MSXML2.DOMDocument.4.0\
Collection of paths that Ambassador uses. Ambassador reads and writes from the following keys, mostly during installation:
HKEY_CLASSES_ROOT\.axml HKEY_CLASSES_ROOT\axmlfile HKEY_CLASSES_ROOT\CLSID\interlace.* HKEY_CURRENT_USER\Software\interlace HKEY_LOCAL_MACHINE\Software\Microsoft\Code Store Database\Distribution Units\ HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Excel\Addins\ HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Management\ARPCache\ HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\ModuleUsage\ HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\SharedDLLs\ HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Uninstall\
Additionally, Ambassador maps from file extension to application using the registry by looking up the extension (for example, .xls) in the registry. The value for this key is a progID. If you look up the progID under HKEY_CLASSES_ROOT, you will find information on starting the appropriate application. Ambassador uses this information both directly and indirectly. You may encounter problems if you use a computer with incorrect Excel configurations.
Check the following registry:
HKEY_CLASSES_ROOT\.xls
for the following setting:
HKEY_CLASSES_ROOT\.xls @="ExcelViewer.Sheet.8" "Content Type"="application/vnd.ms-excel"
The user's registry has an application called “ExcelViewer” listed as reponsible for .xls files. It should appear as follows:
HKEY_CLASSES_ROOT\.xls @="Excel.Sheet.8" "Content Type"="application/vnd.ms-excel"
This is an indication that at some time the user (or an administrator) installed the Excel Viewer application over Excel. Changing the registry (as indicated above) will fix the problem. Reinstalling Excel should also correct the problem.