How To Fix UPB342 - MS Excel is set up as display tool for layout &2 in &1

UPB342 - Overview

• Message type: E = Error

• Message class: UPB - BPS: Balance sheet planning messages

• Message number: 342

• Message text: MS Excel is set up as display tool for layout &2 in &1

What causes this issue?

You assigned a planning layout to the planning folder for which
Microsoft Excel is set up as the display tool.
In folders with seperate output areas, the system presents all layouts
with ALV grid controls on execution in the SAP GUI, even when a layout
is set for output with Excel. However, in this case the system starts
an instance of Microsoft Excel on execution which remains invisible.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Proceed in one of the following ways:
If you only want to execute the folder in the Web browser (with the BSP
application UPB_PM02), then you can ignore this message.
If you want to execute the folder in the SAP GUI, then in the planning
environment in the second step of the Layout Builder, set "SAP ALV
Grid" as the display tool for the layout.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message UPB342 - MS Excel is set up as display tool for layout &2 in &1 ?

  The SAP error message UPB342 indicates that Microsoft Excel is set up as the display tool for a specific layout in the SAP Business Planning (BPC) or SAP BusinessObjects Planning and Consolidation (BPC) environment. This error typically occurs when there is an issue with the configuration or setup of Excel as the display tool.
  
  Cause:
  
  Excel Not Installed or Not Configured Properly: The error may occur if Microsoft Excel is not installed on the machine or if it is not configured correctly in the SAP system.
  Incorrect Layout Settings: The layout specified in the error message may not be set up correctly or may be missing required components.
  Compatibility Issues: There may be compatibility issues between the version of Excel and the version of SAP BPC being used.
  User Authorization: The user may not have the necessary authorizations to access the layout or to use Excel as a display tool.
  
  
  Solution:
  
  Check Excel Installation: Ensure that Microsoft