SAP Knowledge Base Article - Public

2331625 - Where is the Worksheet Type option located within the EPM Plugin for Analysis Office?

Symptom

When using the EPM plugin within Analysis Office the Worksheet Type is not listed within the Tools\Options\Sheet Options menu location. Where can the Worksheet Type option be found?

Environment

Analysis Office 2.1.0 or newer

Resolution

The Worksheet type within Analysis Office is now located within the connection pane of the EPM Add-in.

This change is also documented in the SAP Note 2263812 - Cohabitation of EPM add-in 10.0 and AO 2.1 & beyond versions

Here are the steps to access the Worksheet Type options.

  • Open Excel and go to the EPM ribbon.
  • Logon to the EPM Add-in connection.
  • At this time the EPM Pane is visible at the right side of Excel.
  • Click on the connections button within the EPM Pane.

1_Connection.jpg

  • Click on the 'Display By Worksheet' option.

2_Display_worksheet.jpg

  • Highlight a worksheet and at this time the 'Worksheet Type' option is available.

3_Worksheet Type.jpg

Keywords

PLUGIN Work Sheet AO EXCEL CLIENT book workbook , KBA , EPM-XLS , EPM Excel Client , How To

Product

SAP Analysis for Microsoft Office 2.6 ; SAP BusinessObjects Analysis 2.1, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.2, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.3, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.4, edition for Microsoft Office ; SAP BusinessObjects Analysis for Microsoft Office 2.5