Copying Data Between Excel, Word, and PowerPoint

In Smart View, you can copy data from Excel and paste it into Word or PowerPoint. The data you copy and paste is dynamic between Office applications. You can copy and paste data from:

Excel to Word and PowerPoint
Word to Word and PowerPoint
PowerPoint to Word and PowerPoint

The data points retain their original Excel-based query information, enabling you to perform data analysis. Word and PowerPoint can contain data points from multiple data sources, such as Essbase, Financial Management, and Hyperion Enterprise within one document.

Notes

Dynamic data points are maintained only in Word and PowerPoint. If you copy and paste data points within Excel, the data points are not linked to the Excel grid.
When copying and pasting from Word to PowerPoint, or vice versa, data is displayed in a straight line. The tabular format is preserved only when copying data from Excel into Word or PowerPoint.
Numeric formatting in Excel is preserved when data is pasted into Word and PowerPoint. Apply numeric formatting in Excel before copying and pasting data.
If the name of the connection to the data source contains a semicolon (;), you may not be able to paste function data points.
Copying and pasting data points is limited to use with grids and functions. You cannot copy and paste data points from forms.

To copy and paste data from Excel, Word, or PowerPoint to Word or PowerPoint:

Select a data cell or range (may or may not include members).
From the Smart View ribbon, select Copy.
Open a Word or PowerPoint document.
When asked if you want to create a connection, click Yes.
From the Smart View ribbon, select Paste.
Refresh.
Note:
If you paste data into a Word document and save it in a different format such as .htm or .mht, you cannot refresh the data in these other formats.
Optional: To change the POV in Word or PowerPoint after you paste the data, click Manage POV and follow the procedure in Selecting Members for the Default POV.

Retrieving Spreadsheets From Which Data Points Were Copied

To retrieve the Excel spreadsheets from which data points were copied:

In a Word or PowerPoint document into which Excel data points were pasted, select a data cell.
From the data source ribbon, select Visualize in Excel.
If asked to log on the data source, enter the user name and password.
Excel displays the spreadsheet associated with the data cells. You can perform ad hoc analysis on the data.