There have been a lot of posts about copy/paste and copy/paste special not working properly lately. Pecoflyer has sent some information that may help on this matter; it is quoted below.
Since the 13th of March (2012), there has been a large number of complaints that the Paste Special option in Excel (and Word) offers fewer options than it normally does.
Initially it wasn't clear what caused this problem, but it's starting to look like a recent update to the Skype Click-to-Call browser add-in is the culprit.
So if you are experiencing problems with Paste Special in Excel or Word, in particular if you can only paste as plain text, and if you have the Skype Click-to-Call add-in, you may consider disabling or uninstalling this add-in until Skype releases a fix.
Feel free to post any other solutions to copy/paste problems in Excel in this topic.
Regards,
Don