Symptom
Whenever you select an option that should be permanent in Analysis Office (AFO), such as:
- The "free text fields" message that comes up every time you open AFO, even though you keep selecting the "Do not show again" box.
- The Web Service URL that always has the default "http://<boe server hostname>:<port>/dswsbobje/services/Session" and nothing else is in the dropdown.
Environment
- SAP Analysis for Microsoft Office All versions
Reproducing the Issue
Choose option to not appear again next time you use AFO and they will be forgotten, then you will have to choose them again, as per examples above.
Cause
Missing files in one of the required folders below:
- %APPDATA%\SAP\Cof
- %PROGRAMDATA%\SAP\Cof
Resolution
Uninstall and install again AFO from scratch, in order to refresh files on OS level and make the same available to record the choices. Recover missing files.
Keywords
AFO, Analysis Office, remembering, settings, previous, users, install, uninstall, choices, refresh , KBA , BI-RA-AO-XLA , Excel Addin , Problem
Product
SAP Analysis for Microsoft Office all versions