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
- Open SAP Analytics Cloud, add-in for Office.
- Attempt to use the "Refresh All" option for multiple tables.
- 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
- Uninstall existing Microsoft Office from the user's machine.
- 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
SAP Knowledge Base Article - Public