Skip to Content
0

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

Nov 02, 2016 at 01:53 PM

176

avatar image

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

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

1 Answer

Stephen Hobbs Nov 02, 2016 at 02:15 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded