The program used to create this object is htmlfile. Adding an attachment to Word? The Word version is actually 2013, on an office PC. About errors I had in the past with INSERT>OBJECT>Package (as in the screenshot).
Troubleshooting
Problem
User opens Word document. User double-clicks on an Excel table that has been 'embedded' inside Word. An error appears.
Symptom
Steps to reproduce:1. Launch Word
2. Click 'Insert - Object'
3. Choose 'Microsoft Excel Worksheet'
4. Click OK
5. Double-click on the table (that appears in Word)
- - Notice how it successfully opens in Excel:
6. Save this file (for example as 'TEST.DOCX')
7. Close Word
8. Double-click on file 'TEST.DOCX' (to open in Word)
9. Double-click on the table (embedded in Word).
- - An error appears.
Error message:
Depending on the environment, slightly different errors may appear:
Example #1
- The program used to create this object is Excel. That program is either not installed on your computer or it is not responding. To edit this object, install Excel or ensure that any dialog boxes in Excel are closed.
- Microsoft Word
The server application, source file, or item cannot be found.
Example #3
Nothing happens:
Cause
Limitation (reference APAR PI89783) of the Controller add-in architecture, from 10.2.1 onwards.
More Information:
IBM have investigated this issue,a nd have concluded that it is not directly caused by IBM (Controller) code. Instead, it is triggered by a limitation of Microsoft's Word program.
- Specifically, Word (with embedded Excel objects) does not release Excel when closing.
- This means that (with the current design of Microsoft Word) there is no method for IBM to modify its Controller code to solve the problem.
For more information about this, see third-party (Microsoft) discussion (link at the end of this Technote) where the comment is:
'When you close the Word doc with the embedded Excel it doesn't close the Excel instance, so Excel stays running in background in a hidden way. When you open that Word document again and you try to edit the embedded Excel you will get a message error because it is trying to run an additiona instance of Excel. So you need to go to your Task Administrator and close that Excel instance before. After this, Microsoft Word will let you edit that embedded Excel'.
Environment
This problem has been seen using the following versions of Microsoft Office:- Office 2010
- Office 2013
- Office 2016
Resolving The Problem
Fix:Await a future version of Microsoft Excel, which may contain a fix for this limitation.
Workaround:
Temporarily disable the Controller COM add-in.
Steps:
The steps vary slightly depending on the Excel version.
- The below steps are based on Excel 2013:
1. Launch Microsoft Excel
2. Click 'File - Options':
3. Click section 'Add-ins':
4. Ensure that 'Manage' is set to 'COM Add-ins', and click 'Go':
5. Untick the box 'Cognos Controller Link for Microsoft Excel':
6. Click OK
7. Test.
Internal Use Only
RC Oct 2016: Created for PMR# 06689,019,866
RC Oct 2017:
- PMR# 28401,010,618
- Collaboration 122167
- Defect 73792
- APAR 122994 / PI89783 EXCEL PROCESS IS NOT CLOSED, WHEN IT'S EMBEDDED IN WORD
- More Information:The problem only affects Controller 10.2.1 onwards. This is because earlier versions of Controller used a 'simple' VBA Excel Add-In (.xla) rather than COM.From Controller 10.2.1 onwards, the Excel link was redesigned to take advantage of the Microsoft Component Object Model (COM) Add-in capability of MS Office. Therefore, Controller 10.2.1 (onwards) now uses a Dynamic Link Library (.xll) format.This change was done to allow compatibility with more modern versions of MS Office.
Related URL
[{'Business Unit':{'code':'BU002','label':'Business Analytics'},'Product':{'code':'SS9S6B','label':'Cognos Controller'},'Component':'Controller','Platform':[{'code':'PF033','label':'Windows'}],'Version':'10.4.1;10.4.0;10.3.1;10.3;10.2.1','Edition':'}]
Document Information
Modified date:
18 October 2019
18 October 2019