Copying Data Between Excel, Word, and PowerPoint

In Oracle Smart View for Office, you can copy data from Excel and paste it into Excel, 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

  • Excel to Excel (ad hoc only)

  • 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 Oracle Essbase, Oracle Hyperion Financial Management, and Oracle Hyperion Planning 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 can copy data points from forms or Excel pivot tables, but they will be pasted as static text.

  • When you copy and paste a data cell within Excel, note that a Smart View function appears in the Excel formula bar when the pasted cell is selected. This function is generated by Smart View and is not intended to be copied or used as a template for creating other functions.

Watch this video to see a tutorial on integrating data in Office applications, including copying and pasting data points.

video icon Tutorial video

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

  1. Select a data cell or range (may or may not include members).

  2. From the Smart View ribbon, select Copy.

  3. Open a Word or PowerPoint document, or another Excel worksheet or workbook.

  4. If asked if you want to create a connection, click Yes.

  5. From the Smart View ribbon, select Paste.

  6. 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.

  7. 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 or Background POV.

Retrieving Spreadsheets From Which Data Points Were Copied

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

  1. In a Word or PowerPoint document into which Excel data points were pasted, select a data cell.

  2. From the data source ribbon, select Visualize in Excel.

  3. 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.