Excel can’t paste formatted text.

Saturday, April 21st, 2012

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: