3641390 - Error "the table refresh for the model didn’t work properly" in SAC add-in

• The error message "The table refresh for the model didn’t work properly" is displayed when attempting to refresh a report in the SAP Analytics Cloud Excel Add-in.
• The refresh option in the designer panel is marked in red, indicating that the table has not been refreshed.
• The issue happens in a specific SAC Add-in workbook and it works fine in other SAC Add-in workbooks.
• No missing name range is shown in the panel. 
• In the Console tab of the developer's tool, there are some errors about 'Range'.
  • Error Debug info: 
    {code: 'GeneralException', message: 'There was an internal error while processing the request.', errorLocation: 'Range.clear', statement: 'resizedRange.clear();', toString: ƒ, …} 

SAP Analytics Cloud, add-in for Microsoft Office

1. Open the SAC add-in workbook.
2. Observe that the refresh option in the designer panel is marked in red, indicating that the table has not been refreshed.
3. Click on the refresh option, and the error message "The table refresh for the model didn’t work properly" is displayed.

The SAC Add-in workbook is corrupted and also contains a missing named range. 

1. Log out of the SAC Add-in.
2. Delete the affected sheet in the workbook.
3. Log in again to SAC Add-in.
4. Enable the "Restore Corrupted Workbook Objects" option.
5. Restore the workbook objects.
6. Refresh the report. The refresh operation should now work without any issues.

Restore a named range

SAC Excel Add-in, table refresh error, SAP Analytics Cloud, restricted measures, report-level calculations, corrupted workbook, missing named ranges, restore workbook objects, refresh option error, SAC planning model. , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem