3726787 - Delay when switching between refreshed workbooks

A significant lag (3–9 seconds) occurs when switching between two open workbooks after clicking “Refresh All.”  No lag is observed when switching between two workbooks in Excel without refreshing the data source or when Excel is not connected to any backend system.

Error messages observed:

• System.IO.IOException: Unable to write data to the transport connection: An established connection was aborted by the software in your host machine.
• System.Net.Sockets.SocketException: An established connection was aborted by the software in your host machine.
• SAP.Middleware.Connector.RfcConcurrentCallException: cannot execute a call through a busy connection.
• SAP.Middleware.Connector.RfcLogonException: The system is unable to interpret the SSO ticket received.
• SAP.Middleware.Connector.RfcAbapMessageException: The system is unable to interpret the SSO ticket received.
• Com.Sap.Cof.ConnectionService.Http.WebAdapters.ExtendedWebException: The remote server returned an error: (401) Unauthorized.
• Response Info -> Headers: content-encoding: gzip, content-security-policy: frame-ancestors 'self' https://sapanalytics.cloud https://hcs.cloud.sap https://*.live.com https://*.sharepoint.com https://*.online.office.de.
• {"error":"invalid_token","error_description":"The token expired, was revoked, or the token ID is incorrect."}

• SAC Excel Addin
• Analysis for Office 2.8
• EPM Add-in

analysis for office, workbook lag, refresh all, switching workbooks, excel addin, styles issue, custom style explosion, performance degradation, slow switching, trace, error messages, workbook styles , KBA , BI-RA-AO-XLA , Excel Addin , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem