Creating a Default Workbook

You can define a workbook as the default workbook to use as a template for all your workbooks. 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 use a default workbook, go to File→Analysis→Open Data Source. Select a data source and choose OK.

The figure shows the Analysis options for creating and using the Default Workbook.

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.

Watch the video to see how to create and use a Default Workbook.

Let's summarize:

• Default Workbook: Define a workbook template with predefined styles and settings to be used when opening any data source.