Skip to Content
1
Nov 28, 2018 at 07:54 AM

EPM report refresh takes long time when another office program is running.

784 Views Last edit Nov 28, 2018 at 07:56 AM 2 rev

Hi Everyone,

We are working on Windows 10 - Excel 2016 with EPM 33.3 (Also tries with all other combinations like Win 8 - Win 10, Excel 2013, Excel 2016 and EPM versions after 30). BW 740 SP 17, HANA BPC 810 SP 12, BPC 10.1.

When another Microsoft Office program is running in the background like Outlook, Word, Powerpoint, refreshing worksheet or workbook takes a long time. When we close the other office program, Excel is responded immediately and refreshing is finalizing.

Maybe it's not related to the same issue but, at the same time, Clipboard is locked by the Excel and we can't make any copy-paste on anywhere when the workbook is refreshing.

In our reports, we are using the formatting sheets, we have member formulas, we have retrieve data formulas and we have some calculations under default script logic. But this is not the case, refreshing a workbook consist of 17 worksheets is takes 1 minute, but when we open outlook or another office program it takes more than 20 minutes.

Do you have any suggestion to fix this problem?

Your valuable advises are highly appreciated.

Thanks.