Page 98 - Excel Data Analysis

06 537547 Ch05.qxd 3/5/03 2:57 PM Page 84

EXCEL DATA ANALYSIS

LINK DATA TO OTHER

WINDOWS PROGRAMS

ou can quickly copy text and images from virtually dialog box. This option creates a link from the copied data
any other Microsoft Windows document and paste in your worksheet back to the original file. Excel monitors
Y them directly into Excel for analysis using the Copy the original document for any changes, and reflects them
and Paste commands. You can then link the Excel worksheet immediately in the copied data in the worksheet.
to the other document.
Pasting data in your worksheet as a link requires that you
When you paste data from another program, Excel inserts keep all of the pasted text intact. You can apply any
the data directly into the selected cell and attempts to formatting to the pasted data, but you cannot separate any
maintain any original formatting. Excel separates text links that it may contain once you have it in Excel. For this
containing hard returns and tabs into different cells starting reason, this option does not work well for data analysis.
at the location of the tab or hard return.
You only use the Paste link option when you copy data
The Paste command only places a copy of the original from a program that supports Object Linking and
selection into the worksheet. To prevent having to re-copy Embedding (OLE), a technology that links information
and re-paste any updates or modifications to the original between different programs.
text, you can use the Paste link option in the Paste Special

LINK DATA TO OTHER WINDOWS PROGRAMS

⁄ In the desired Microsoft ¤ Click Edit ➪ Copy. ‹ In Excel, select the cell › Click Edit ➪ Paste Special.
Windows program, select the where you want to paste the
data you want to copy into copied data.
Excel.

84