Show TOC

To insert a data source into a default workbookLocate this document in the navigation structure

You can define a workbook as the default workbook. The styles, formatting and the workbook settings that you defined in the default workbook are used when you open a data source. If you save the default workbook on a server, you can share it with other users.

If you do not define a default workbook, the data source is opened with the SAP standard settings.

To open a data source with the default workbook

  1. Open a data source in Analysis.

    In Microsoft Office 2010, choose Start of the navigation path File Next navigation step Analysis Next navigation step Open Data Source End of the navigation path.

    In Microsoft Office 2007, press the Microsoft Office button and choose Start of the navigation path Open Next navigation step Data Source End of the navigation path.

    In Microsoft Excel 2003, choose Open Data Source in the Analysis Standard toolbar.

  2. Log on to a platform and system.

    For more information, see To insert a data source in a workbook

  3. Select a data source.
  4. Press OK.

A new workbook with the data from the selected data source is created using the styles, formatting and workbook settings that you defined in the default workbook for the first inserted data source. All elements that you have defined for the first data source of your workbook are displayed with the data from the new selected data source. If the default workbook contains more than one data source, the elements from the other data sources are also displayed with the data from the corresponding data sources.

To open a data source without a default workbook
If you do not define a default workbook in the user settings, the data source is opened with the following Analysis default settings:
  • The crosstab is inserted starting in cell A1 in the worksheet.
  • The default style set is used for formatting. SAP style set SAP Black&White is the initial default.
Related Information