Paste Special when copying from applications other than Excel
You can use the Paste Special dialog to copy complex items from an application other than Excel and paste them into an Excel worksheet.
Source
Displays the name of the source data and its location. If you copied the data from an application that did not provide the source data and its location to the Clipboard, the source is identified as "Unknown."
Inserts or embeds the Clipboard contents at the insertion point in the format specified in the As box. When you select this option, the Clipboard contents are pasted or embedded, but no link is created.
Select the Paste link check box to link the pasted data to its source document.
Specifies the type of information you want to paste from the Clipboard.
Displays the Clipboard contents as an icon. Use this option if you do not want linked data to be displayed in your file.