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)