SAP Knowledge Base Article - Public

3758682 - "Open in Excel Add-in" is greyed out in table based on the model containing User-Managed date dimension in SAP Analytics Cloud (SAC)

Symptom

  • "Open in Excel Add-in" is greyed out in table based on the model containing User-Managed date dimension
  • It is able to insert this model into SAC Excel Add-in directly
  • This issue would occur on both Edit mode and Full Viewer Mode of the story

Environment

  • SAP Analytics Cloud 2026.8.6

Reproducing the Issue

  1. Log onto SAC 
  2. Create a model with User-Managed date dimension
  3. Create an optimized story based on this model as below steps
  4. Navigate to the Edit mode of the story
  5. Insert a table into this story
  6. Add the dimension and measure into this table
  7. Navigate to the Table Properties on Builder Panel and check on the option "Enable Excel Add-in"
  8. Go back to the table, click on the three dot graph button beside the table and check the option "Open in Excel Add-in"
    => Observe that this option is greyed out

Cause

  • This is currently a by designed behaviour.
  • This limitation was introduced in SAC 2026 QRC2 update because workbooks created could show unexpected data after opening. 

Resolution

  • This is currently a by designed behaviour.
  • "Open in Excel Add-in" is greyed out in SAC story table based on a model containing user managed date dimension / flexible time dimension.
  • In principle this limitation is the same as for the scenario "Launch Data Analyzer from Story".

See Also

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, optimized, variable, ID, description, table, excel, add-in , KBA , LOD-ANA-TAB , Table , Problem

Product

SAP Analytics Cloud 1.0