---
title: Insert Data Sources in SAP Analysis for Microsoft Office
description: Learn two different methods to insert data sources into a workbook in SAP Analysis for Microsoft Office.
image: https://blog.sap-press.com/hubfs/How%20to%20Insert%20Data%20Sources%20into%20a%20Workbook%20in%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/)

[Business Intelligence](https://blog.sap-press.com/tag/business-intelligence)

# Insert Data Sources in 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)

In this blog post, let’s walk through inserting data sources into a workbook in SAP Analysis for Microsoft Office.

 

To create a new workbook with a data source, SAP Analysis for Microsoft Office must be installed locally on your computer. You can either connect directly to an [SAP BW](https://learning.sap-press.com/sap-data-management#SAP-Business-Warehouse) system or use a connection to an SAP BusinessObjects BI platform to insert data sources. The same platforms can be used to save workbooks and share them with other users.

 

We’ll discuss two methods to insert data sources into a workbook. We’ll use the SAP NetWeaver platform for examples. However, you can transfer the procedure seamlessly to SAP BusinessObjects BI.

 

## Inserting Data Sources via the Analysis Tab

To insert a data source, first, select a cell of the workbook into which the crosstab with the data should be inserted (e.g., cell B3). Then, under the **Analysis** tab, click on the **Insert Data Source** dropdown list (1) in the **Data Source** menu group, as shown here.

 

![Inserting a New Data Source](https://blog.sap-press.com/hs-fs/hubfs/2004_01_001.png?width=845&name=2004_01_001.png)

 

If you’ve previously used data sources, these data sources will be displayed in a list (2). You can select and insert a data source with a single click, which will speed up your work because you won’t have to search for a specific data source.

In the list of previously used data sources, only the description and the system are initially visible. Unfortunately, these descriptions are not unique. Thus, different queries with the same description can exist in one system. If you mouse over the name of the data source, the technical name of the data source is also displayed, as shown in the next figure. In contrast to the description, this name is unique. In reality, only one query has this name.

![Displaying the Technical Name of the Data Source](https://blog.sap-press.com/hs-fs/hubfs/2004_01_002.png?width=673&name=2004_01_002.png) 

If you have not yet added any data sources or cannot find the desired data source in the list, you can select the **Select Data Source for Analysis...** option (3), shown earlier.

 

Now, by default, the dialog box for logging on to the SAP BusinessObjects BI platform opens, as shown below. If you’re using an SAP BusinessObjects BI platform, enter the relevant information into the **User**, **Password**, and **Web Service URL** fields to log on. If you’re using SAP NetWeaver as your platform, click the **Skip** button.

 

![Logging On to the SAP BusinessObjects BI Platform](https://blog.sap-press.com/hs-fs/hubfs/2004_01_003.png?width=868&name=2004_01_003.png)

**1**

**Automatically Skipping the SAP BusinessObjects BI Platform Logon Step**: The dialog box for logging on to the SAP BusinessObjects BI platform appears every time you log on, even when you’re not using the system. However, this default behavior rarely makes sense since only a few companies use the platform.

 

Therefore, we recommend setting SAP NetWeaver as the default platform and thus hiding the logon screen for the SAP BusinessObjects BI platform. To configure this setting, switch to the **File** tab, found in the upper-left corner of the screen. Then, select the **Analysis** option from the list, as shown here.

![Analysis Option in the File Tab](https://blog.sap-press.com/hs-fs/hubfs/2004_01_004.png?width=1085&name=2004_01_004.png)

 

Then, click on the **Customize Analysis** option and select **Options**.

 

![Changing SAP Analysis for Microsoft Office Options](https://blog.sap-press.com/hs-fs/hubfs/2004_01_005.png?width=1013&name=2004_01_005.png)

 

A dialog box displaying options for SAP Analysis for Microsoft Office will open. Switch to the **Platform** tab, shown below. Then, select the **Business Warehouse** option from the **Preferred Platform** dropdown list. Confirm the changes by clicking the **OK** button. Your SAP BW platform is now used by default, and you do not have to skip the logon dialog box of the SAP BusinessObjects BI platform every time.

 

![Defining a Preferred Platform](https://blog.sap-press.com/hs-fs/hubfs/2004_01_006.png?width=1267&name=2004_01_006.png)

 

A list of SAP BW systems is now displayed, as shown in the next figure. Select the system that is relevant for you (1) and then click on the **Next** button (2).

 

![Selecting Your SAP BW System](https://blog.sap-press.com/hs-fs/hubfs/2004_01_007.png?width=1155&name=2004_01_007.png)

 

The **Logon to System** dialog box will be displayed, shown below. Enter your user name in the **User** field and your password in the **Password** field and confirm by clicking the **OK** button. Optionally, you can specify a desired language in the **Language** field.

![Logging On to the Selected SAP BW System](https://blog.sap-press.com/hs-fs/hubfs/2004_01_008.png?width=768&name=2004_01_008.png)

**Changing Passwords**: If you log on with an initial password (set up by your administrator) or your password is no longer valid, the dialog box for changing the password opens automatically. In these cases, you no longer need to log on using the SAP GUI, as was the case with earlier versions of SAP Analysis for Microsoft Office.

 

The **Select Data Source** dialog box will now be displayed, as shown in the next figure. To select a data source, you can use the **Area** (in this case, the InfoArea), **Role**, **Workspaces**, or **Environments** (SAP BPC) tabs (1). Alternatively, you can search for a specific data source using the **Search** tab. Use the dropdown list (2) to specify whether you want to search descriptions, technical names, or both.

 

![Selecting a Data Source](https://blog.sap-press.com/hs-fs/hubfs/2004_01_009.png?width=1165&name=2004_01_009.png)

 

You can also restrict the data source type (3). For example, you can define that only the **InfoProvider**, **Query**, or **Query View** type is searched. You can also use all possible combinations for the search.

 

After you define the desired data source type, enter a search term in the search bar (4). Then, click the **Search** button or press the (Enter) key to start the search.

 

**Wildcard Search**: SAP Analysis for Microsoft Office supports wildcard searches. For example, you can type an \* (asterisk) to search for data sources that begin with a specific string. For example, if you enter TAOB\* in the search bar, the system will search for all data sources that begin with TAOB. In this example, the InfoProviders TAOBMCOMP, TAOBRPLAN, and TAOB0\_201 and the query TAB0\_201\_PP\_0001 might be delivered as results.

 

The results are displayed with a description and a technical name of each matching object (5). Select the desired data source and confirm your selection by clicking the **OK** button (6). A new crosstab with the data of the selected data source will be inserted into the workbook.

**Using Styles**: By default, the SAP style SAP Blue is applied to the crosstab. This style determines, for example, the size of the font and the background color of cells. You can adjust how data is displayed by selecting among several predelivered templates. To view templates, select the **Styles** dropdown list in the **Format** menu group under the **Analysis Design** tab and then select the **Apply Style Set** option, as shown in the following figure. Now, you can choose between different style sheets. Alternatively, you can also customize each cell individually or define your own styles.

 

![Selecting a Style](https://blog.sap-press.com/hs-fs/hubfs/2004_01_010.png?width=733&name=2004_01_010.png)

 

Now, you can analyze the data or adjust the display to suit your needs. You can also enrich your workbook with other components, for instance, diagrams for visualization.

 

**Faster Route to the Desired Display**: You can activate the **Pause Refresh** function in the **Design Panel** menu group (under the **Analysis** tab) before inserting a data source, as shown here.

 

![Pause Refresh Button](https://blog.sap-press.com/hs-fs/hubfs/2004_01_011.png?width=252&name=2004_01_011.png)

For example, you can carry out an evaluation in the **Analysis** view of the **Design Panel** without incurring loading times. You can adjust columns, rows, and filters so that only a relevant section of the data contained in the data source is displayed, as shown in this figure. Instead of first loading the entire dataset and then navigating to your desired results, only the desired information is loaded from the beginning. The crosstab with the analysis you defined is only added if you deactivate the **Pause Refresh** function again.

 

![Adjusting Your Analysis](https://blog.sap-press.com/hs-fs/hubfs/2004_01_012.png?width=1110&name=2004_01_012.png)

## Inserting Data Sources via the File Tab

Another way to insert a data source is via the **File** tab. Select the **Analysis** option and then click on the **Open Data Source** dropdown list. In the dropdown list, you can select the **Load Recent List** option to display data sources that have been previously used. If the desired data source does not appear in the list, select the **Open Data Source** option, as shown here.

 

![Opening a Data Source](https://blog.sap-press.com/hs-fs/hubfs/2004_01_013.png?width=827&name=2004_01_013.png)

 

Then, as described earlier, you must log on to a system and select the desired data source. Afterwards, the corresponding data will be inserted into the workbook, as shown here.

![Inserted Data Source](https://blog.sap-press.com/hs-fs/hubfs/2004_01_014.png?width=948&name=2004_01_014.png)

 

Note that this path is intended for working with so-called default workbooks. If no default workbook has been defined, the default settings will be used when the data source is opened. The crosstab will be inserted into your worksheet, starting from cell A1. The style defined as standard is also used for formatting.

 

## 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_chapter1&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-1.jpg?width=170&name=2004-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_chapter1&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_chapter1&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!

[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%2Fhow-to-insert-data-sources-into-a-workbook-in-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%2Fhow-to-insert-data-sources-into-a-workbook-in-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%2Fhow-to-insert-data-sources-into-a-workbook-in-sap-analysis-for-microsoft-office%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fblog.sap-press.com%2Fhow-to-insert-data-sources-into-a-workbook-in-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%2Fhow-to-insert-data-sources-into-a-workbook-in-sap-analysis-for-microsoft-office%3Futm_medium%3Dsocial%26utm_source%3Demail&body=Check+out+https%3A%2F%2Fblog.sap-press.com%2Fhow-to-insert-data-sources-into-a-workbook-in-sap-analysis-for-microsoft-office%3Futm_medium%3Dsocial%26utm_source%3Demail)

### Comments

### Latest Blog Posts

[![Prompting with Variants in SAP Analysis for Microsoft Office](https://blog.sap-press.com/hs-fs/hubfs/Using%20Prompting%20with%20Variants%20in%20SAP%20Analysis%20for%20Microsoft%20Office.png?height=600&name=Using%20Prompting%20with%20Variants%20in%20SAP%20Analysis%20for%20Microsoft%20Office.png)](https://blog.sap-press.com/prompting-with-variants-in-sap-analysis-for-microsoft-office)

[Business Intelligence](https://blog.sap-press.com/tag/business-intelligence)

## [Prompting with Variants in SAP Analysis for Microsoft Office](https://blog.sap-press.com/prompting-with-variants-in-sap-analysis-for-microsoft-office)

[Read More](https://blog.sap-press.com/prompting-with-variants-in-sap-analysis-for-microsoft-office)

[![Technical Configuration of SAP Analysis for Microsoft Office](https://blog.sap-press.com/hs-fs/hubfs/Technical%20Configuration%20of%20SAP%20Analysis%20for%20Microsoft%20Office.png?height=600&name=Technical%20Configuration%20of%20SAP%20Analysis%20for%20Microsoft%20Office.png)](https://blog.sap-press.com/technical-configuration-of-sap-analysis-for-microsoft-office)

[Programming](https://blog.sap-press.com/tag/programming)

## [Technical Configuration of SAP Analysis for Microsoft Office](https://blog.sap-press.com/technical-configuration-of-sap-analysis-for-microsoft-office)

[Read More](https://blog.sap-press.com/technical-configuration-of-sap-analysis-for-microsoft-office)

**Subscribe to our blog!**Get notified about future blog updates.

- <https://www.facebook.com/sappress>
- <https://twitter.com/sappress>
- <https://linkedin.com/company/sap-press>
- <https://www.instagram.com/sap_press/>
- <https://blog.sap-press.com/rss.xml>

### 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-04-29T16:30:24.054Z",
  "datePublished" : "2022-04-04T13:00:00.000Z",
  "headline" : "Insert Data Sources in SAP Analysis for Microsoft Office",
  "image" : [ "https://blog.sap-press.com/hubfs/How%20to%20Insert%20Data%20Sources%20into%20a%20Workbook%20in%20SAP%20Analysis%20for%20Microsoft%20Office.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://blog.sap-press.com/how-to-insert-data-sources-into-a-workbook-in-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."
  }
}
```