Managing settings of AfO

Settings or configuration of Analysis for Office (AfO) was done via adjusting an registry settings for AfO of version 1.x in a client machine. However, this was changed and as of version, 2.x the configuration of the AfO tool can be done via maintaining XML configuration files. There are the config files available for Administrator and regular user. There are 2 files available for each of user:

Files for administrator are located in folder: %PROGRAMDATA%\Sap\Cof

        Ao_app.config

Cof_app.config

And for user in folder: %APPDATA%\Sap\Cof

Ao_user_roaming.config

Cof_user_roaming.config

Another way to access the settings is via Excel menu File -> Analysis -> Customize Analysis -> Technical Configuration.

More info:

2083067 - How to maintain settings for Analysis Office 2.x

Online docu