Problem with copy & paste in Excel 2010

Anonymous
2012-03-16T10:47:34+00:00

I am running Excel 2010 on Windows 7. I am having a problem with the cut and paste command. This has worked OK for the few months I have been using the program, but the paste options have suddenly stopped working properly.  When I click on paste special, the only options shown are unicode text or text, with no explanation. When I copy and paste formulas, e. g. autosum,  it is not applying them properly to the selected cells, or it is just pasting the values of the copied cells. I have tried uninstalling and reinstalling Office Home and Business 2010, but the problem is still there. Any ideas?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
HansV 462.7K Reputation points MVP Volunteer Moderator
2012-04-11T19:23:19+00:00

Skype has released an updated version of the Click to Call browser add-on that should be free of the problem mentioned above.

If you want it, go to http://www.skype.com/intl/en-us/get-skype/on-your-computer/click-to-call/windows/ and click Download Now.

Moderator Note

For more information on this issue, please see the following sticky:

Text loses formatting when I use Cut, Copy, Paste, Paste Special or Format Painter in Excel

Was this answer helpful?

50+ people found this answer helpful.
0 comments

60 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2012-06-07T00:11:29+00:00

    Exactly the same. Close IE Explorer and Excel worked just fine.

    I am running under:

    Windows 7 Enterprise Service Pack 1

    IE 9 and MS Office Professional Plus 2010

    Excel 2010

    32 bit

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-06-06T06:51:57+00:00

    Since my last reply, I have run the repair to Microsoft Office feature through the control panel/programs and features/change.

    This seemed to work at first, and the paste options were restored, and data and formulas were being pasted correctly.

    However, although it worked properly  immediately after the repair, the problem has returned.

    When I copy a cell with an autosum formula and paste to another cell, the corrrect formula is shown on the new cell, but it displays the value from the copied cell. The paste options have disappeared again.

     

     

    Hi..All.....Above repair MS Office is worked for me. Now im able to see the dot.dot / surrounded dot marks after copy .........Cheers !!! :)

    Thanks so much guys for your post  ! !

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-06-05T11:00:11+00:00

    Skype has released an updated version of the Click to Call browser add-on that should be free of the problem mentioned above.

    If you want it, go to http://www.skype.com/intl/en-us/get-skype/on-your-computer/click-to-call/windows/ and click Download Now.

    I have just experienced the same issue after installing the latest Skype update but the above "Click-to-Call" update resolved the issue after clearing the browser cache (IE9) and restarting the browser. The issue only came up on the Win7 32 / Office 10 machine

    • not on Win7 64 / Office 10 or any others. Thank you HansV for sharing. Kind Regards.

    Was this answer helpful?

    0 comments
  4. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more