Closed Thread
Page 1 of 3 1 2 3 LastLast
Results 1 to 15 of 33

excel 2010 - paste special - not working

  1. #1
    Registered User
    Join Date
    03-14-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    4

    excel 2010 - paste special - not working

    When I try to use paste special to copy a format or a formula the box that usually gives you the : formula, Values formats etc etc is no longer there I just get a box giving the option for text or unicode text - how can I get this to alter back so I ahve the other option - HELP

  2. #2
    Registered User
    Join Date
    03-14-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: excel 2010 - paste special - not working

    If you are copying plain text, you can only paste that text, so that box will show up as it has no formatting in the first place. Check your copy source. Maybe you copied the text in the cell instead of the cell itself?
    Dim Prawny As Newb

  3. #3
    Registered User
    Join Date
    03-14-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: excel 2010 - paste special - not working

    HI

    Thanks for that but I am not copying plain text - I am trying to copy a formula or a format - it was working till yesterday and I am using the same spreadsheet on another computer and it is working normally. should i re install my excel programme

  4. #4
    Registered User
    Join Date
    03-14-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: excel 2010 - paste special - not working

    Are you copying the formula from the formula bar or the actual cell on the spreadsheet?

  5. #5
    Registered User
    Join Date
    03-14-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: excel 2010 - paste special - not working

    copying the formula from the cell - it works on my other computer

  6. #6
    Registered User
    Join Date
    03-14-2012
    Location
    Bay Area, California
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: excel 2010 - paste special - not working

    Did you figure out the problem? I am having the same issue.

    I will copy a cell with a formula. When I try to paste it only give me the Paste Text Option.

  7. #7
    Registered User
    Join Date
    03-14-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: excel 2010 - paste special - not working

    No - still got same problem - think I am going to reinstall software and see if that works

  8. #8
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: excel 2010 - paste special - not working

    if you first choose Edit | Cut, Paste Special is greyed out.

    If you first choose Edit | Copy, Paste Special is available.

  9. #9
    Registered User
    Join Date
    03-14-2012
    Location
    Bay Area, California
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: excel 2010 - paste special - not working

    Quote Originally Posted by grizzly6969 View Post
    if you first choose Edit | Cut, Paste Special is greyed out.

    If you first choose Edit | Copy, Paste Special is available.
    Actually, now the cut function is not working either. I cut (Ctrl+x) a cell then paste to a diferent cell. In the formula in orginal cell remained. New cell displays value of the orginal cell. It also allows me to paste in as many cell as I want. If memory servers you can only paste a cut cell once.

    If I right click . Under the Paste Option only has one clipboard shown "A" Keep Text Only (t) displayed.
    If I choose past special then I get as Unicode Text or Text.

  10. #10
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: excel 2010 - paste special - not working

    can you post your workbook without sensitive information so we can take a look at it

  11. #11
    Registered User
    Join Date
    03-14-2012
    Location
    Bay Area, California
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: excel 2010 - paste special - not working

    Quote Originally Posted by grizzly6969 View Post
    can you post your workbook without sensitive information so we can take a look at it
    I could but I don't think it would mater in this case. I discovered a little bit more about the issues. My Excel works fine if I don't have the Internet Explorer open. When IE is open it acts like I'm trying to paste someting into excel from IE. This is truly odd. I'm not sure how to resolve the issue is it with Excel or IE? I'm going to see if it work with Chrome open.

    any suggestions?

  12. #12
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: excel 2010 - paste special - not working

    it sounds like there is a link that is trying to update
    Have you downloaded an add in
    Last edited by grizzly6969; 03-14-2012 at 04:45 PM.

  13. #13
    Registered User
    Join Date
    03-14-2012
    Location
    Bay Area, California
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: excel 2010 - paste special - not working

    Same issue with Chrome. I thought I had fixed the problem with a system restore but it seems the issue continues.
    Last edited by ACS66; 03-14-2012 at 05:37 PM.

  14. #14
    Registered User
    Join Date
    03-14-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: excel 2010 - paste special - not working

    I have the same problem on this computer - my other one (also W7 + Office 2010) works fine. Both are completely up to date with MS patches and service packs etc.

    To clarify, can only paste plain test or Unicode if either IE9 or Chrome is open. This PC had a clean install 3 days ago. If you want to know why, look at my blog at http://christitcumb.wordpress.com/

  15. #15
    Registered User
    Join Date
    03-15-2012
    Location
    Iowa
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: excel 2010 - paste special - not working

    I'm having the same issue with Excel 2010. I was not having this issue earlier in the week. [IGNORE: Timing seems to be after installing 03/14/2012 MS updates.]

    UPDATE: I am having this issue anytime I attempt to Copy and Paste when a browser (Chrome, FF 10, IE 9) is running. As soon as I close the browser, I can then Copy and Paste normally (note: excel stays open - no need to close and reopen program or file).

    UPDATE 2: Found Safari, tested excel Copy and Paste, no issues.
    Last edited by cdj; 03-15-2012 at 02:08 PM.

Closed Thread
Page 1 of 3 1 2 3 LastLast

Thread Information

Users Browsing this Thread

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

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