To create a slide out of Microsoft Excel

Prerequisites

You have inserted a data source in Analysis, edition for Microsoft Excel.

Context

Out of the edition for Microsoft Excel, you can create a slide with a crosstab or chart that is currently displayed in the workbook. In Microsoft PowerPoint, the current navigation state of the objects in Excel is displayed, but the objects exist independently in Excel and PowerPoint. After the creation of the slide, navigation steps in Excel do not affect the objects in PowerPoint and vice versa.

Procedure

In the edition for Microsoft Excel, select the crosstab or chart that should be displayed on the slide.
Choose Create Slide.
The edition for PowerPoint opens automatically.
If you are not already logged on to the system in the edition for Microsoft PowerPoint, enter your User and Password and press OK.

If a crosstab includes more rows than can be displayed on a slide, the Fit Table dialog box appears. In this dialog, you can define if the crosstab should be splitted to multiple slides or displayed abbreviated in one slide.
Optional step: Change the view on the data.
You can change the view on the data in Microsoft PowerPoint using the funtions of the Analysis ribbon.
You can use the undo/redo in the Anaylsis ribbon to undo and redo steps that you executed with functions in the Analysis ribbon. To undo/redo steps that you executed with Microsoft Powerpoint, for example the deletion of a crosstab, you should use the undo/redo of Microsoft Powerpoint.
Optional step: Change the formatting of a crosstab.
To change the formatting of a crosstab, select the crosstab and choose Table Tools Design Table styles. . Select a style to apply it to the crosstab.
In the Table Style Options group, you can define the display of rows and columns. If you select Header Row and First Column, the formatting is only applied to the first header row and first column even if your Analysis crosstab contains more than one header rows or columns with member information. The formatting will be applied to these rows and columns after the next Analysis refresh.

Note You should not use the other options in the Table Tools ribbon to format an Analysis crosstab. If you use them, your changes will be overwritten with the next Analysis refresh.
Optional step: You can define specific settings for Analysis in Microsoft Powerpoint in the Presentation Settings dialog.

To open this dialog, choose Settings Presentation Settings .

Results

The selected object is displayed on a Microsoft PowerPoint slide.

Corresponding to workbooks, you can save a presentation to the business intelligence platform server and open it from there. Choose the Microsoft Office Button and Save/Open Presentation.