Skip to Content
avatar image
Former Member

Analysis for Office 2.5 - Severe performance issues with Office365

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....

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 01 at 01:05 PM

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

    Source: SAP Insider

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 01 at 01:48 PM

    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).
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 05 at 04:27 PM

    No other SAP customer with these performance issues??

    Add comment
    10|10000 characters needed characters exceeded