Skip to Content

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

Nov 02, 2016 at 01:53 PM


avatar image
Former Member

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 :

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.



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

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



10 |10000 characters needed characters left characters exceeded