SAP Knowledge Base Article - Public

3664247 - "refresh all" Error "The table refresh for model didn’t work properly." in SAP Analytics Cloud, add-in for Office

Symptom

  • When attempting to use the "Refresh All" option for tables in SAP Analytics Cloud, add-in for Office, the following error is displayed: "The table refresh for model didn’t work properly."
  • Sometimes the "Refresh All" option works initially but fails during subsequent attempts.
  • Refreshing tables individually does not produce any errors, indicating the issue is specific to the "Refresh All" functionality.

Environment

SAP Analytics Cloud, add-in for Microsoft Office

Reproducing the Issue

  1. Open SAP Analytics Cloud, add-in for Office.
  2. Attempt to use the "Refresh All" option for multiple tables.
  3. Observe the error message: "The table refresh for model didn’t work properly."

Cause

Incorrect channel version of Microsoft Office installed on the system. Semi-Annual Enterprise Channel version of Microsoft Office is the recommended platform for Analysis for Office 2.8
Check version installed. 3597802 - How to check the current release of Microsoft 365 Apps 

Resolution

Semi-Annual Enterprise Channel version of Microsoft Office is the recommended platform for Analysis for Office 2.8

  1. Uninstall existing Microsoft Office from the user's machine.
  2. Install the Semi-Annual Enterprise Channel version of Microsoft Office 

See Also

Keywords

SAP Analytics Cloud, add-in for Office, refresh all error, table refresh issue, Microsoft Office channel, semi-annual enterprise channel, compatibility issue, troubleshooting guide, error message, model refresh failure, SAC Excel add-in. , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem

Product

SAP Analytics Cloud 1.0