Skip to Content
avatar image
Former Member

AFO : sheet type defaut value "Non-COF Worksheet"

I work with AFO 2.2 on Office 2016 (same effects to office 2013)

When I used excel, the AFO addin is launched, my excel files are very slowed without the analysis functions (no queries into the files). I check the trace and I found a solution : Go to panel display / components / sheets / change the Sheet type by "Non-COF Worksheet".

Found here : https://blogs.sap.com/2016/05/10/how-to-ignore-worksheets-from-analysis-office-processing-and-improve-performance/

Now I work with a lot of files and I can not change this parameter into all my sheets files.

Is it possible to configure this parameter per defaut ?

I can uninstall the tool, change the all conf files like "Ao_user_roaming.config" or upgrade to 2.3.

Thank for your help.

Regards,

Goulwen

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 02, 2016 at 02:15 PM

    Hi Goulwen,

    If I understand your question correctly, note 1899658 - Too many styles slow down or crash Analysis Office might be worth looking at too. We often have cases of hundreds of unused styles in a workbook which prevent it opening in Excel when the Add-In is active...

    Regards,

    Stephen

    Add comment
    10|10000 characters needed characters exceeded