we use BI IP and have workbooks with 5 to sometimes 10 planqueries (located on individual worksheets). We notice that the performance in BEX is bad. The planning functions itself are performant ( less that 5 seconds in the modeler). However in the excell workbook everything is slow;
opening: 30 seconds - 3 minutes.
simple save: at least 30 seconds
planning function: more or less the same as the save.
=> when performing a trace with ST05 (when clicking on save for example) we don't see much happening. Also in SM50 we don't see much happening.
Does anyone has experienced the same (or the opposite?) Is this problem caused by SAP or by Microsoft Excell?? Are the figures above normal???