SAP Knowledge Base Article - Public

3802547 - Log in when opening a downloaded workbook - SAP Analytics Cloud, add-in for Microsoft Office

Symptom

After opening an Excel workbook downloaded from SAP Analytics Cloud, the user must sign in to the tenant again in the SAP Analytics Cloud add-in to refresh data or access the model.

Environment

  • SAP Analytics Cloud, add-in for Microsoft Office

Reproducing the Issue

  1. Download an Excel workbook from the SAP Analytics Cloud tenant.
  2. Open the workbook in Excel.
  3. In the SAP Analytics Cloud add-in, attempt to refresh data or access the underlying model.
  4. Observe that a sign-in to the associated tenant is required.

Cause

The access/session token from the original SAP Analytics Cloud browser session is not stored in the downloaded Excel file, so the add-in cannot reuse it for authentication.

Resolution

Sign in to the SAP Analytics Cloud tenant in the add-in when prompted to refresh data or access models; this is expected behavior.

Keywords

SAP Analytics Cloud add-in, Excel add-in, Office add-in, auto login, auto sign-in, tenant login, sign-in prompt, token, session token, access token, workbook download, refresh data, model access, by design, expected behavior , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem

Product

SAP Analytics Cloud all versions