Error message : SOFFICEINTEGRATION143

[Former Member]

Hi

Iu2019m making my planning layout in T-Code u2013 KEPM when I execute the planning method, I received this error message: Error while opening document.

Can anybody help me to resolve this error? Please see the message:

Error while opening document

Message no. SOFFICEINTEGRATION143

Diagnosis

An error occurred in the desktop application while opening a document.

Procedure

Check first whether you can insert a document from this desktop application as an embedded object in another application. The necessary menu item is usually 'Insert --> Object'. The application then lists all of the OLE document types. Choose the type corresponding to the desktop applciation. If the insertion fails, the error is in the desktop application itself.

This error has various causes. Often, it is caused by activating certain add-ins. Sometimes, the desktop application is wrongly installed. The error should not recur once you have disabled any add-ins or reinstalled the desktop application.

Procedure for System Administration

If you cannot solve the problem as described above, enter a problem message. There are notes relating to how to generate the log file using the program SAPROFFICEINTEGRATIONTRACE.

Regards

Louie

PS. We upgrade our SAP gui to 7.2 version

[fernando_evangelista]

Hi Louie,

The most errors occur because the Microsoft Excel template stored

in Transaction KP34 for the corresponding layout is incorrect.

You cannot avoid this in advance since you have formatting options

(which cannot be deactivated) in Excel that result in problems in case

of an inplace.

Please check the following steps.

For each planning with active Integrated Excel the system needs a

template Excel sheet ("Template"), which is filled with the current

data (in accordance with the specifications on the initial screen)

upon the call of the planning screen.

In the profile maintenance (Transaction KP34), you can save a

separate template for every layout, e.g. to store color changes.

This template is stored in the R/3 system. If no separate template

exists for the current layout, the system uses an empty standard

template which contains the macros necessary for planning "only".

Error message SOFFICEINTEGRATION143 indicates that a separate

incorrect template was saved. In the most cases users

removed or hid lines lines while setting-up the template in

Transaction KP34, or he even stored own macros.

To repair the incorrect template presumably makes no sense, however,

since there is a "link" between the layout and the template,

removing the layout and inserting it afterwards again into the

planner profile often does not even help to make the layout

accessible again.

Using the utility program KPP7UT03 you can delete existing

templates. Here, it is important that you make a restriction to the

layout in question on the initial screen, since otherwise the system

may delete several (or even all !) Thus you should make the

following specifications:

a) Planner profile,

b) Subclass (always 01),

c) Table name (Planning area -> F4 input help) and

d) Planning layout.

The profile item is only relevant if a layout has been entered more

than once in the same profile. The program has no test run.

Afterwards the empty standard template is used again for the

respective layout.

For more detailed analyses of the template used in each case you can

save this onto your own hard disk as follows:

a) Set a breakpoint in function module KPP_XL_TEMPLATE_GET_COPY.

b) Call up the planning transaction, go to the planning screen.

c) When the function module is reached, "empty" variable I_MODUS.

d) Set a breakpoint to success message K9353.

e) Continue processing (F8).

f) The system generates a dialog box on which you can specify the target location of the Excel file.

g) Continue processing (F8).

h) Cancel the transaction when you reach the breakpoint.

You can now examine the template . Especially for recurring problems you can access the

changes stored this way.

Also recommend to check note 499152.

I hope it helps.

Regards,

Fernando Evangelista