Share via

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.6K Reputation points
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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-03-17T07:20:53+00:00

    Are you able to use paste special options in other Office applications?

    Try opening Excel in safe mode and check if the issue re-occurs.

    Click on Start > All Programs > Accessories > Run > Copy and Paste the following command in the open box and press Enter.

    Excel /safe

    If Excel safe works as expected, disable the add-ins:

    a) Click on File menu, click Options > Add-ins > Go button besides Manage: Com-Add-in.

    b) Check if there are add-ins listed, clear the checkbox to disable them.

    c) Close the Office program and restart it. 

    d) Disable each add-in one at a time, restart the Excel, and repeat the above procedure. If the issue reappears again, it will help you to determine which add-in is causing this issue.

    Was this answer helpful?

    100+ people found this answer helpful.
    0 comments
  2. Anonymous
    2012-03-17T13:02:50+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.

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments
  3. Anonymous
    2012-03-17T11:34:48+00:00

    I have tried opening Excel in safe mode as suggested, but the problem is still there.

    It appears that paste special is not working properly in Word either. When I click on paste special

    I get 'source unknown' and two options - unformatted text and unformatted inicode text.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  4. Anonymous
    2012-03-19T08:24:24+00:00

    I have exactly the same problem and have tried all the approaches you have but with the same result. Can anybody help?

    Was this answer helpful?

    0 comments