Paste Special

SS
The paste special options are slightly different depending on what is on the clipboard and whether you are just pasting to pasting as a link.
At the very top of the paste special dialog box there is an indication as to what is on the clipboard.

Copying within Document - Paste

Microsoft Office Word Document Object
Formatted Text (RTF)
Unformatted Text

Copying within Document - Paste Link

Microsoft Office Word Document Object
Formatted Text (RTF)
Unformatted Text

Copying Excel Chart - Paste

Microsoft Office Excel Chart Object - also includes a "display as icon" checkbox ?
Picture (Windows Metafile)
Bitmap
Picture (Enhanced Metafile)
Picture (GIF)
Picture (PNG)
Picture (JPEG)
Microsoft Office Graphic Object

Copying Excel Chart - Paste Link

Importing > Links Dialog
Importing > Chart Object

Microsoft Office Excel Chart Object - They all includes a "display as icon" checkbox ?
Picture (Windows Metafile)
Bitmap
Microsoft Office Graphic Object

Copying Excel Range - Paste

Copying Excel Range - Paste Link

Importing > Links Dialog
Importing > Worksheet Object

Microsoft Office Word Document Object

Formatted Text (RTF)

Unformatted Text

Unformatted Unicode Text