I had an odd excel issue today. My co-worker asked if I had seen a situation where you loose the ability to paste formatted text to a spreadsheet.
I had a look at his office 2010 setup and nothing obvious was missing and there were no error messages to suggest a problem.
I right-clicked a cell and selected “Paste Special..” and found the only option left was unicode text.
Even though I knew it would not solve it; I ran a repair on office.
I checked around the Net and found a few suggestions to edit the cells via vba through the alt-F11 command but they did not solve the problem.
I searched the Microsoft site and found an article about the clipboard loosing the ability for format pasting.
The problem seems to center around the use of Skype’s Click to Call.
This seemed odd but we tried disabling it on the browser and the add-ons for Excel and Word. The problem remained.
We ended up uninstalling Click to Call and after restarting the browser and Excel; we found the ability for formatted pasting had returned.
Lesson of the day: The integrated clipboard can cause problems after installing new software.