--- title: Technical Configuration of SAP Analysis for Microsoft Office description: Explore the technical configuration of SAP Analysis for Microsoft Office in this blog post. Look at basics, changing the technical configuration, add ins, and more. image: https://blog.sap-press.com/hubfs/Technical%20Configuration%20of%20SAP%20Analysis%20for%20Microsoft%20Office.png --- [![rheinwerk-sappress-logo-header-1](https://blog.sap-press.com/hubfs/rheinwerk-sappress-logo-header-1.svg)](https://blog.sap-press.com/) [Blog](https://blog.sap-press.com) - Books - Get an overview of our books and courses on every relevant SAP topic. - [Programming](https://sap-press.com/programming/) - [Administration](https://sap-press.com/administration/) - [BI](https://sap-press.com/business-intelligence/) - [Finance](https://sap-press.com/finance-controlling/) - [Logistics](https://sap-press.com/logistics/) - [HR](https://sap-press.com/human-resources/) - [CRM & Sales](https://sap-press.com/marketing-sales/) - [HANA](https://sap-press.com/hana/) - [Introductions](https://sap-press.com/introductions/) - [E-Bites](https://sap-press.com/e-bites/) - [Certification Guides](https://www.sap-press.com/certification-guides/) - [Rheinwerk Courses](https://www.sap-press.com/online-courses/) - Book Subscription - Get unlimited access to all SAP PRESS books! - [SAP PRESS Subscription](https://sap-press.com/subscriptions/) [Programming](https://blog.sap-press.com/tag/programming) # Technical Configuration of SAP Analysis for Microsoft Office ![SAP PRESS](https://blog.sap-press.com/hubfs/Twitter_profile_pic.svg) by [SAP PRESS](https://blog.sap-press.com/author/sap-press) This blog post introduces you to the basics of the technical configuration for SAP Analysis for Microsoft Office.   Considerably more parameters are available to you than appear in the **Options** dialog box. You can also define which settings users can adjust and which are defined centrally. In addition to administration using the file system, a graphical interface is also available for technical configuration. Then, we’ll discuss the individual settings for the SAP Analysis for Microsoft Office add-in and the SAP Analysis for Microsoft Office plug-in in detail.   ## Basics SAP Analysis for Microsoft Office settings are stored in the system as *.config* files. As an administrator, you can maintain the settings in the *Cof\_app.config*, *Ao\_app.config*, *Bpc\_app.config*, and *Epm\_app.config* files. These files are located in the file system under *C:\\ProgramData\\SAP\\Cof*. The central settings for the SAP Analysis for Microsoft Office add-in are maintained in the *Cof\_app.config* file. In the other files, plug-in-specific settings are maintained. For example, the *Ao\_app.config* file maintains the parameters for the SAP Analysis for Microsoft Office plug-in, the *Bpc\_app.config* file maintains the parameters for the SAP Business Planning and Consolidation (SAP BPC) plug-in, and the *Epm\_app.config* file maintains the parameters for the SAP Enterprise Performance Management (SAP EPM) plug-in. In this section, we’ll focus on the settings for SAP Analysis for Microsoft Office.   In these files, you can specify, for example, whether users have the right to change a setting locally, which is controlled by the configurationLevel attribute, as shown in the figure below (1) in the ConfigSections section (2). A configuration level is defined for each setting. The default level is UserRoaming, which means that users can adjust the setting locally. If you change the configuration level in PerMachine, users can no longer change the setting locally.   ![Insight into a Configuration File](https://blog.sap-press.com/hs-fs/hubfs/2204_12_29.png?width=1775&name=2204_12_29.png)   You can therefore use the configurationLevel attribute in ConfigSections to control who can maintain the settings. The settings themselves are maintained in the area below. The default value of each parameter is always displayed in the comment for the individual parameters. This value is used by default, unless otherwise specified. Below shows an example.   ![Maintaining Parameter Values](https://blog.sap-press.com/hs-fs/hubfs/2204_12_30.png?width=1225&name=2204_12_30.png) **Analysis Updates:** If you change the settings under *C:\\ProgramData\\SAP\\Cof*, your changes may be lost when you install a new version of SAP Analysis for Microsoft Office. You should therefore save the file with the changed settings in a different folder. After installing the new version, you can reuse the saved file.   You can maintain user-specific settings in the folder *C:\\Users\\\[User name\]\\AppData\\Roaming\\SAP\\Cof*. The configuration files are *Cof\_user\_roaming.config* and *Ao\_user\_roaming.config*. These files are automatically created when you change a setting in the **Technical Configuration** dialog box. You can also create the files manually. If a setting is not yet available, you can copy it from the files under *C:\\Program-Data\\SAP\\Cof*. ## Changing the Technical Configuration In addition to managing the settings directly in the configuration files, you can adjust the settings using the **Technical Configuration** dialog box in SAP Analysis for Microsoft Office, which is much more convenient, since the interface offers not only better clarity, but also filter options.   To open the **Technical Configuration** dialog box, switch to the **File** tab and select **Analysis**. Then, select the **Technical Configuration** option from the **Customize Analysis** dropdown list, as shown here. ![Open Technical Configuration](https://blog.sap-press.com/hs-fs/hubfs/2204_12_31.png?width=830&name=2204_12_31.png)   The dialog box shown in the next figure appears. Via the search bar (1), you can search for a specific setting. You can also filter settings by prefix (2). If you search for *Cof*, the central settings for the SAP Analysis for Microsoft Office add-in are displayed. The other settings are specific to the SAP Analysis for Microsoft Office plug-in. For example, the prefix *Ao* is used to maintain the parameters for the SAP Analysis for Microsoft Office plug-in, *Bpc* is used for the SAP BPC plug-in, and *Epm* stands for the SAP EPM plug-in. In this section, we’ll focus on the settings for SAP Analysis for Microsoft Office. ![Technical Configuration Dialog Box](https://blog.sap-press.com/hs-fs/hubfs/2204_12_32.png?width=1627&name=2204_12_32.png)   You can also filter by the type of settings. If you select the **All Settings** option from the **Settings** dropdown list (3), all settings are displayed. If you select **All Settings Deviating From Default Value**, only settings that have already been changed are displayed. The **All Settings Containing a Value in File** option displays all settings that contain a value in the corresponding file (for example, *Ao\_user\_roaming.config* if **Ao** was selected as the prefix or *Cof\_user\_roaming.config* if **Cof** was selected as the prefix).   You can directly adjust the value of a selected setting (4). Depending on the type, you can select the checkbox for Boolean values or enter an integer value or text.   In the detail view, which you can expand by clicking on the plus button, shown above next to **PreferredPlatform**, you’ll get more information about the respective setting. In the **Type** dropdown list, you get the expected type of the value. This type can be Bool for Boolean values, Int32 for integer values, or String for text. For Boolean values, the value is True if the checkbox is selected.   Under **Default** (5), the default value of the setting is displayed for orientation. This value is used by default unless otherwise specified. The value for **Publish** is always True, which means that the setting is public. **Allowed Configuration Level** (6) allows you to adjust the configuration level. The configuration level can be either UserRoaming or PerMachine.   Users can change settings with the UserRoaming configuration level. The changed settings are stored in the file system under *C:\\Users\\\[User Name\]\\AppData\\Roaming\\SAP\\Cof*. The file names for the changed settings are *Cof\_user\_roaming.config*, *Ao\_user\_roaming.config*, *Bpc\_user\_roaming.config*, and *Epm\_user\_roaming.config*. These files are created automatically when you change a setting using the **Technical Configuration** dialog box.   An administrator can also change the settings with the PerMachine configuration level. The changed settings are stored in the file system under *C:\\ProgramData\\SAP\\Cof*. The file names are *Cof\_app.config*, *Ao\_app.config*, *Bpc\_app.config*, and *Epm\_app.config*.   As an administrator, you can change the configuration level from UserRoaming to Per- Machine for each setting. These settings can then no longer be changed by users.   You can also derive the corresponding file from the configuration prefix. The prefix *Cof* stands for the add-in, *Ao* for the SAP Analysis for Microsoft Office plug-in, *Bpc* for the SAP BPC plug-in, and *Epm* for the SAP EPM plug-in. The path to the configuration file in the file system is also displayed under **Loaded From**.   Clicking the **OK** button saves your changes. The changed values are then available in the **Technical Configuration** dialog box and in the corresponding files in the file system.   ## Settings for the SAP Analysis for Microsoft Office Add-In In this section, we’ll briefly describe the settings that you can define for the SAP Analysis for Microsoft Office add-in. These settings are stored in the *Cof\_app.config* file. This configuration file is divided into several sections: - In the ConnectionServiceConfiguration section, you can adjust the settings for the SAP connector for Microsoft .NET, which is used to call ABAP remote function calls (RFCs) from the client. - In the AppBuilderConfiguration section, you’ll find profile-relevant settings. - In the DPPConfiguration section, you can configure the data protection popup window. - In the OfficeConfiguration section, you can specify whether the SAP Analysis for Microsoft Office add-in should be supported when the Microsoft Office tools are executed in embedded mode (also known as automated mode). - In the SupportConfiguration section, the clientProfiling setting allows you to switch the profiling mode on and off. - Finally, in the VersionConfiguration section, you can use the MinorVersion setting to specify a version to be used. ## Settings for the SAP Analysis for Microsoft Office Plug-In In this section, we’ll briefly describe the settings that you can define for the SAP Analysis for Microsoft Office plug-in. These settings are stored in the *Ao\_app.config* file. The configuration file is divided into several sections: - In the BoeConfiguration section, you can define settings for your SAP Business- Objects BI platform. - In the DataSourceConfiguration section, you define settings for the data source and the system. - In the DateTimeConfiguration section, you can customize the time and date display. - In the DocumentConfiguration section, you find the settings for your workbook. - In the FormulaConfiguration section, you can control the assignment of filter values using the setting. - In the GridConfiguration section, you can define settings for the crosstab. - In the HanaConfiguration section, you can define a possible timeout for an SAP HANA HTTP connection. - In the NavPaneConfiguration section, you can configure the **Analysis** view in the **Design Panel**. - In the NewLinesConfiguration section, you can switch off the new line validation if necessary. - In the PlanningConfiguration section, you can define settings relevant to planning. - In the SelectorConfiguration section, you can customize the behavior of the filter dialog box. - In the TaskPaneConfiguration section, you can configure the **Design Panel**. - In the UICommonConfiguration section, you can adjust settings that affect the general user interface. - In the UtilitiesConfiguration section, you can adjust system-relevant parameters. - In the VariableConfiguration section, you can define the behavior of variables. - In the WaterfallChartConfiguration section, you can define the display of waterfall diagrams. - In the WorkbookConversionConfiguration section, you can adjust the settings for the conversion of your workbooks.  In addition, the configuration file also contains obsolete parameters for customizing the look and feel of the user interface, such as EnableWorkspaces or ShowPlanningToolbar. You should no longer use these parameters, but instead use profiles to customize the user interface.   [Learn more about SAP data management on this page](https://learning.sap-press.com/sap-data-management).   ## Learn SAP Analysis for Microsoft Office in Our Upcoming Rheinwerk Course! Turn your Excel workbook into a powerful SAP reporting and planning hub! In three expert-led course days, you’ll learn essential skills for working with SAP data directly in Microsoft Excel. Click on the banner below to learn more and order your ticket.   [![blog_courses_054_SAP_Analysis_Microsoft](https://blog.sap-press.com/hs-fs/hubfs/blog_courses_054_SAP_Analysis_Microsoft.png?width=600&height=200&name=blog_courses_054_SAP_Analysis_Microsoft.png)](https://www.sap-press.com/online-courses/sap-analysis-for-microsoft-office/)   *Editor’s note*: This post has been adapted from a section of the book [*SAP Analysis for Microsoft Office—Practical Guide*](https://www.sap-press.com/sap-analysis-for-microsoft-office-practical-guide_5155/?utm_source=sappressblog&utm_medium=referral&utm_campaign=Blogs&utm_term=2004_chapter12&utm_content=2004)by Denis Reis. ## Recommendation [![SAP Analysis for Microsoft Office—Practical Guide](https://blog.sap-press.com/hs-fs/hubfs/social-suggested-images/2004-3-1.jpg?width=170&name=2004-3-1.jpg)](https://www.sap-press.com/sap-analysis-for-microsoft-office-practical-guide_5155/?utm_source=sappressblog&utm_medium=referral&utm_campaign=Blogs&utm_term=2004_chapter12&utm_content=2004) **SAP Analysis for Microsoft Office—Practical Guide** Managing your SAP data in Microsoft Excel? This is your guide to using SAP Analysis for Microsoft Office! Get started with the basics, from creating your first workbook to navigating through reports. Then, follow step-by-step instructions to process data, analyze data, develop planning applications, customize reports, and work with tools such as formulas and macros. Including details on troubleshooting, UI customization, and more, this book is your all-in-one resource! [Learn More](https://www.sap-press.com/sap-analysis-for-microsoft-office-practical-guide_5155/?utm_source=sappressblog&utm_medium=referral&utm_campaign=Blogs&utm_term=2004_chapter12&utm_content=2004) ![SAP PRESS](https://blog.sap-press.com/hubfs/Twitter_profile_pic.svg) **by [SAP PRESS](https://blog.sap-press.com/author/sap-press)** SAP PRESS is the world's leading SAP publisher, with books on ABAP, SAP S/4HANA, SAP IBP, intelligent technologies, SAP Business Technology Platform, and more! [Programming](https://blog.sap-press.com/tag/programming) [Business Intelligence](https://blog.sap-press.com/tag/business-intelligence) [![Share on facebook](https://7528309.fs1.hubspotusercontent-na1.net/hub/7528309/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/facebook-color.png?width=24&name=facebook-color.png)](https://www.facebook.com/share.php?u=https%3A%2F%2Fblog.sap-press.com%2Ftechnical-configuration-of-sap-analysis-for-microsoft-office%3Futm_medium%3Dsocial%26utm_source%3Dfacebook) [![Share on linkedin](https://7528302.fs1.hubspotusercontent-na1.net/hub/7528302/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/linkedin-color.png?width=24&name=linkedin-color.png)](https://www.linkedin.com/shareArticle?mini=true&url=https%3A%2F%2Fblog.sap-press.com%2Ftechnical-configuration-of-sap-analysis-for-microsoft-office%3Futm_medium%3Dsocial%26utm_source%3Dlinkedin) [![Share on twitter](https://7528304.fs1.hubspotusercontent-na1.net/hub/7528304/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/twitter-color.png?width=24&name=twitter-color.png)](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Fblog.sap-press.com%2Ftechnical-configuration-of-sap-analysis-for-microsoft-office%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fblog.sap-press.com%2Ftechnical-configuration-of-sap-analysis-for-microsoft-office%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=) [![Share on email](https://7528311.fs1.hubspotusercontent-na1.net/hub/7528311/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/email-color.png?width=24&name=email-color.png)](mailto:?subject=Check+out+https%3A%2F%2Fblog.sap-press.com%2Ftechnical-configuration-of-sap-analysis-for-microsoft-office%3Futm_medium%3Dsocial%26utm_source%3Demail&body=Check+out+https%3A%2F%2Fblog.sap-press.com%2Ftechnical-configuration-of-sap-analysis-for-microsoft-office%3Futm_medium%3Dsocial%26utm_source%3Demail) ### Comments ### Latest Blog Posts [![SAP OKB9 Explained: Automatic Account Assignment for FI-CO Postings](https://blog.sap-press.com/hs-fs/hubfs/SAP%20OKB9%20Explained_%20Automatic%20Account%20Assignment%20for%20FI-CO%20Postings.jpg?height=600&name=SAP%20OKB9%20Explained_%20Automatic%20Account%20Assignment%20for%20FI-CO%20Postings.jpg)](https://blog.sap-press.com/sap-okb9-explained-automatic-account-assignment-for-fi-co-postings) [FICO](https://blog.sap-press.com/tag/fico) ## [SAP OKB9 Explained: Automatic Account Assignment for FI-CO Postings](https://blog.sap-press.com/sap-okb9-explained-automatic-account-assignment-for-fi-co-postings) [Read More](https://blog.sap-press.com/sap-okb9-explained-automatic-account-assignment-for-fi-co-postings) [![Configuring Ad Hoc Issue Management in SAP Process Control](https://blog.sap-press.com/hs-fs/hubfs/Configuring%20Ad%20Hoc%20Issue%20Management%20in%20SAP%20Process%20Control.png?height=600&name=Configuring%20Ad%20Hoc%20Issue%20Management%20in%20SAP%20Process%20Control.png)](https://blog.sap-press.com/configuring-ad-hoc-issue-management-in-sap-process-control) [FICO](https://blog.sap-press.com/tag/fico) ## [Configuring Ad Hoc Issue Management in SAP Process Control](https://blog.sap-press.com/configuring-ad-hoc-issue-management-in-sap-process-control) [Read More](https://blog.sap-press.com/configuring-ad-hoc-issue-management-in-sap-process-control) **Subscribe to our blog!**Get notified about future blog updates. - - - - - ### The official SAP PRESS Blog As the world’s leading SAP publisher, SAP PRESS’ goal is to create resources that will help you accelerate your SAP journey. The SAP PRESS Blog is designed to provide helpful, actionable information on a variety of SAP topics, from SAP ERP to SAP S/4HANA. Explore ABAP, FICO, SAP HANA, and more! ### SAP Blog Topics - [All Topics](https://blog.sap-press.com) - [Logistics](https://blog.sap-press.com/tag/logistics) - [Programming](https://blog.sap-press.com/tag/programming) - [FICO](https://blog.sap-press.com/tag/fico) - [Administration](https://blog.sap-press.com/tag/administration) - [Business Intelligence](https://blog.sap-press.com/tag/business-intelligence) - [What Is?](https://blog.sap-press.com/tag/what-is) - [Featured](https://blog.sap-press.com/tag/featured) - [CRM & Sales](https://blog.sap-press.com/tag/crm-sales) - [Video](https://blog.sap-press.com/tag/video) - [Human Resources](https://blog.sap-press.com/tag/human-resources) ### Blog curated by [![Rheinwerk Publishing & SAP PRESS Logo](https://blog.sap-press.com/hubfs/rheinwerk-sappress-logo-header-1.svg)](https://sap-press.com) [Visit the SAP PRESS Store](https://sap-press.com) ### About - [Home](https://sap-press.com/) - [About Us](https://sap-press.com/the-publisher/) - [Contact](mailto:info@rheinwerk-publishing.com) - [Legal Notes](https://sap-press.com/legal-notes/) - [Privacy Policy](https://sap-press.com/privacy/) - [Terms of Use](https://sap-press.com/terms/) - [Guest Posting](https://blog.sap-press.com/guest-posting) © 2026 Rheinwerk Publishing, Inc. | Change Privacy Options ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "SAP PRESS", "url" : "https://blog.sap-press.com/author/sap-press" }, "dateModified" : "2026-08-26T15:31:57.141Z", "datePublished" : "2022-08-03T13:00:00.000Z", "headline" : "Technical Configuration of SAP Analysis for Microsoft Office", "image" : [ "https://blog.sap-press.com/hubfs/Technical%20Configuration%20of%20SAP%20Analysis%20for%20Microsoft%20Office.png" ], "mainEntityOfPage" : { "@id" : "https://blog.sap-press.com/technical-configuration-of-sap-analysis-for-microsoft-office", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://blog.sap-press.com/hubfs/Logo-1.jpg" }, "name" : "Rheinwerk Publishing, Inc." } } ```