Skip to Content
0

Analysis for Office 2.5 - Severe performance issues with Office365

Mar 01 at 12:57 PM

65

avatar image
Former Member

We are having issues with our Analysis for Office 2.5 (SP04, P1) performance together with Office365 ProPlus, version 1708 (build 8431.2215 click to run) locally installed on a win10 laptop.


After an (automatic) upgrade to this Excel version there are performance issues while scrolling or using arrows to navigate in the workbook (big lag before it responds). When there is no AFO connection there are no performance issues.

This is in general for all workbooks with an AFO connection. The more data there is in the workbook; the bigger the performance issue. We did not have this before with the previous build (I think it was 1704).

Reinstalling AFO and/or Office suite did not resolve this issue. We have it in the whole company on every user's machine who uses AFO.


Are more people experiencing this? Is there any solution for it? Please advise....

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Tammy Powlas
Mar 01 at 01:05 PM
0

Hello - please see this video to help troubleshoot performance - you can analyze where the performance issue is.

Source: SAP Insider


troubleshoot.jpg (95.5 kB)
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 01 at 01:48 PM
0

I know this option as it has helped us before. But now it does not show profiling statistics (I start it AFTER the report fetched the data, because afterwards is when the issue occurs), it is in the scrolling/navigating within the Excel sheet. (Excel memory consumption

seems higher with the same report than before the update with same dataset/workbook).
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 05 at 04:27 PM
0

No other SAP customer with these performance issues??

Share
10 |10000 characters needed characters left characters exceeded