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

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?

Analysis Office 2.1.0 or newer

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.

• Click on the 'Display By Worksheet' option.

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

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

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