To smart copy/paste a data source

Prerequisites

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

Context

You can copy a data source (crosstab or chart) that is currently displayed in the workbook. You can then insert the copied data source in the edition for Microsoft Excel and the edition for Microsoft PowerPoint.

Procedure

In the edition for Microsoft Excel, select the crosstab or chart that should be copied.
Choose Smart Copy.
Select an empty cell in the sheet and choose Smart Paste.
The copied data source is inserted as crosstab.

Results

The current navigation state of the copied data source is displayed, but it exists independently from the origin. Navigation steps in the original object do not affect the pasted crosstab and vice versa.

In the edition for Microsoft PowerPoint, you can paste a data source as crosstab or chart.