+ Reply to Thread
Results 1 to 10 of 10

Copy not working properly Excel 2010

  1. #1
    Registered User
    Join Date
    04-13-2012
    Location
    Huddersfield, England
    MS-Off Ver
    Excel 2010
    Posts
    7

    Question Copy not working properly Excel 2010

    I use 2 laptops and share spreadsheets between them. A problem I had on one laptop is now happening on the other.

    In some spreadsheets, the copy function does not work properly. When I right click to select copy I can see that the Paste options available are restricted. Then, when I try to paste I can only paste the contents (I only get the box with the letter A in it)- the options to paste formulae, format etc are not avaiable. If I select Paste Special I get a dialogue box with the options to paste as Unicode text or just text.

    More and more spreadsheets are falling foul of this. What causes it and how can I stop it? I hope I can because I have some complicated formulae I need to copy - rewriting long hand would be a nightmare!

    Any help greatly appreciated.

    Flybridge

  2. #2
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Copy not working properly Excel 2010

    Do you by chance have the skype addin installed?
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

  3. #3
    Registered User
    Join Date
    04-13-2012
    Location
    Poulsbo, WA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Copy not working properly Excel 2010

    I have the same problem for Excel 2003, and from what I can tell, I have no Skype addin installed. I can only paste the contents, no formulas. If I select Paste Special I get options to paste as Unicode text or just text.
    Last edited by melQ; 04-13-2012 at 02:18 PM. Reason: add info

  4. #4
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Copy not working properly Excel 2010

    make sure that the workbooks are open in the same instance of excel, if you have more than one instance of excel open and are copying between them you will encounter this issue.

  5. #5
    Registered User
    Join Date
    04-13-2012
    Location
    Poulsbo, WA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Copy not working properly Excel 2010

    I'm having trouble just copying formulas on a single sheet! and it won't allow me to copy one cell & fill in multiple cells.

  6. #6
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Copy not working properly Excel 2010

    is this just in one sheet, or does it happen in many sheets?

  7. #7
    Registered User
    Join Date
    04-13-2012
    Location
    Poulsbo, WA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Copy not working properly Excel 2010

    It's for everything, everywhere.

  8. #8
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Copy not working properly Excel 2010

    The Skype plug in is called Skype Click to Call. It's not an Excel add in. It's a plug in installed in browsers and messes up the clipboard. Check your list of programs in your Control Panel and uninstall it if it's there.

  9. #9
    Registered User
    Join Date
    04-13-2012
    Location
    Poulsbo, WA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Copy not working properly Excel 2010

    Brilliant! DGagnon & Cutter -- you rock!!! The Skype Click to Call seemed to be the culprit! (Of course, I needed to restart before I saw my Excel back to it's normal self) Thank you so much!

  10. #10
    Registered User
    Join Date
    04-13-2012
    Location
    Huddersfield, England
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Copy not working properly Excel 2010

    Sorry for not closing down this thread. I didn't get any emails to say answers had been posted. (I see now I have to specifically ask to get the emails, strange as I started the thread). So I thought it wasn't answered. But one answer works so I have now given some rep for it.

    Many thanks, DGanon.

    Flybridge

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1