Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 341
  • Last Modified:

Excel 2007: Paste Special not working

I've seen this question before, but none of the solutions have worked for me. I am trying to copy a section of a spreadsheet and paste it to another area of the same spreadsheet. However, when I paste it, the result are values, no formulas, just text. I've tried to do the same procedure and use Paste Special instead, but the options are 'greyed out' and instead I get the dialogue "Paste: as Unicode Text or Text" I've been using this function quite a bit and have never encountered this. I'm on a Windows 7 machine, and also on a Windows XP machine. The problem first started on the XP machine. Now none of my spreadsheets work. HELP!!!
0
DMoore8608
Asked:
DMoore8608
1 Solution
 
NorieCommented:
How are you copying the section and what's in it?

Does it work if you just paste?
0
 
byundtCommented:
Do you have Skype installed? There is a recent update that causes a conflict with Click to Talk feature that has symptoms you report. Uninstalling that feature fixes the problem.
0
 
asher-is-meCommented:
Select all of the area where you intend to paste the items, then press the Delete key.  Then try to paste it in.  If it's still happening, copy and paste your entire spreadsheet into a new spreadsheet, and try again.
0
 
DMoore8608Author Commented:
It's hard to believe, but this WAS the problem!! I uninstalled Skypes "Click to Call" from the Windows control panel uninstall software menu. I re-opened my spreadsheet and low and behold, it worked! Didn't have to reboot or anything! Thank you so much!!!
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now