Symptom
Unable to refresh tables created in SAC Excel Addin and receiving error message "The table refresh for model <model> didn't work properly. The argument is invalid or missing or has an incorrect format", as per screen shot below:
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental".
Environment
- SAP Analytics Cloud, add-in for Microsoft Office
Reproducing the Issue
- Open SAC Excel Add-In
- Sign in to the required tenant
- Add the required model
- Change some dimensions and the error message will come up
Resolution
This issue has already been identified in older versions and releases of SAC Excel Add-In and the correction is delivered from SAC Excel Add-In 1.19.0.0 onwards.
See Also
Keywords
Error message, The table refresh for model, didn't work properly, The argument is invalid or missing or has an incorrect format, SAC Excel Add-In , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Known Error