Skip to Content
0
Jan 03, 2023 at 08:11 AM

Live Office Excel refresh taking >20 minutes

52 Views Last edit Jan 03, 2023 at 09:26 AM 2 rev

When prompting Excel to Live Office refresh, it takes ages to load. But also increases every time I refresh. Any help would be appreciated.

Setup:

Excel workbook, one Object. The Object document has one query.

Actions:

I click Refresh All Objects in the Live Office section. Then the Refreshing Object(s) / Rendering [document] shows.

Problem:

Nothing happens until after some 15-20 minutes the data is loaded - everything looking OK (status = succeeded). Last prompt took 1092,781 seconds.

One connection (logging in OK), a webi report with one query.

When triggering the report directly in webi, it takes 10 seconds at most.

Some more info: When I rebuild everything, things load really quick. Then after some weeks, refreshing daily, the refresh time increases drastically. Even if I reduce the scope in the document I try to load. This applies even when I build a completely new report and also connect through a "clean" excel workbook. Worth noticing is that if I press Cancel, it also takes 10 minutes before Excel reacts again - it seems stuck in "cancelling".

Excel Live Office:14.2.7.3487

WEBI: SAP BusinessObjects BI Platform 4.2 Support Pack 9 Patch 6

Version: 14.2.9.4130

Excel: 2202 (build 14931.20806)