Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Can't copy/paste in the same workbook

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Delray Beach, FL
    Posts
    101
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Can't copy/paste in the same workbook

    Hello, I have a workbook with multiple tabs. I'm trying to copy some data from one tab to the next. Walking through the steps:

    I highlight the data I want to copy.
    Right click "Copy"
    Go to the tab where I want to paste
    Right click (and "paste" is grayed out)

    This is all within the same workbook. Any ideas?

  2. #2
    Board Regular
    Join Date
    May 2009
    Location
    Cincinnati
    Posts
    188
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can't copy/paste in the same workbook

    Is the workbook or worksheet protected?

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Delray Beach, FL
    Posts
    101
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can't copy/paste in the same workbook

    No, and I should add that this is Excel 2010, I left that out of my original post.

    When I copy, I get the squiggly lines (like it's copying), click over to the other tab and then back again and the lines are solid.

    So for some reason just clicking the other tab removes the data from the clipboard.

  4. #4
    Board Regular
    Join Date
    Jan 2008
    Posts
    811
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can't copy/paste in the same workbook

    Close all Excel instances, open a blank sheet and type something, then try it again? Does it work? If not I would suggest there is something wrong with Windows Clipboard. Sometimes other programs can take it over, Screen Capture programs, snag it etc.. remote control software that use Keyboard and mouse over several computers etc..

    Reboot maybe?

  5. #5
    Board Regular
    Join Date
    May 2009
    Location
    Cincinnati
    Posts
    188
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can't copy/paste in the same workbook

    If you hit Alt F11, which will open VBA (Visual Basic for Applications) Do you see or have any code in there for your workbook/worksheet?

    Have you installed any add-ins recently?

    You could try this, which I found in another post on this subject:

    Open Excel
    hit alt-f11 (to get to the VBE)
    hit ctrl-g (to see the immediate window)

    type this and hit enter:
    application.commandbars("cell").reset

  6. #6
    Board Regular
    Join Date
    May 2009
    Location
    Cincinnati
    Posts
    188
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can't copy/paste in the same workbook

    I agree - possibly check this as well.

    Close all excel applications and press ctrl/shift and esc to bring up the task manager, click processes tab and end task on any excel.exe processes listed.
    When an excel process gets stuck in memory; every time you open excel it creates a new instance and when you try and paste from one process to another excel assumes you are using an external program and brings a different paste option.

    Multiple excel documents only require a single excel process to be running.

  7. #7
    Board Regular
    Join Date
    Apr 2002
    Location
    Delray Beach, FL
    Posts
    101
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can't copy/paste in the same workbook

    Hi there, yes it is in a workbook that has an add-in as well as VBA. I will have to work with IT to figure out the problem. I figured I'd post here and see if it was a quick fix.

    Thanks!

  8. #8
    New Member
    Join Date
    May 2014
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can't copy/paste in the same workbook

    I have the same problem so I googled and found my way here .

    You are so awesome!! the code totally solved my problem!!

    THANKS ALOT!
    Quote Originally Posted by jhedges View Post
    If you hit Alt F11, which will open VBA (Visual Basic for Applications) Do you see or have any code in there for your workbook/worksheet?

    Have you installed any add-ins recently?

    You could try this, which I found in another post on this subject:

    Open Excel
    hit alt-f11 (to get to the VBE)
    hit ctrl-g (to see the immediate window)

    type this and hit enter:
    application.commandbars("cell").reset

  9. #9
    New Member allewyn's Avatar
    Join Date
    Aug 2008
    Location
    Rogue River OR USA
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can't copy/paste in the same workbook

    Well, this didn't work for me. I have still the same problems. When I try to cut (or copy and paste) I see this message:
    "Excel cannot complete this task with available resources. choose less data or close other applications"
    I have no other applications open and this only happens in this workbook. Somehow and suddenly the workbook is messed up. I have been accued of changing things randomly but I don't think so this time
    I am using Office 2010 on Win7 with 2GB ram

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com