Office 365 Microsoft Excel And Word Issue With SAPGUI

Solman_www.basisguru.com

In this article we will discuss issue we faced after Office 365 migration while using applications MS Excel Word within SAPGUI.

Symptoms:

  • After Office 365 migration,documents within SAP which use Microsoft Excel and Microsoft Word do not open in Embedded SAPGUI window. (within SAP).
  • Instead they open separately (Outside SAP window) while executing SAP transactions that has MS Word /MS Excel to be opened in place.
  • This is also a case with transactions with SAP long text.

Cause:

Issue is caused due to DPI settings. (dots-per-inch resolution).

How To Correct This Issue:

1) For Microsoft Word

  • Open the Microsoft Word application and Goto File –>Options
Microsoft Excel And Word Issue With SAP GUI
Microsoft Excel Word Options_ SAPGUI
  • Choose General->When using multiple displays -> and select option Optimize for Compatibility
Microsoft Word Option optimize for compatibility

Restart MS Word Application.

2) For Microsoft Excel

  • Open the Microsoft Excel application and Goto File –>Options
Microsoft Excel Issue With SAP GUI
  • From File Menu select –>Open Options.
Microsoft Excel Options

Choose General->When using multiple displays -> and select option Optimize for Compatibility

Microsoft Excel Option Optimize for Compatibility

Restart MS Excel Application.