Results 1 to 6 of 6

Thread: I cannot do Copy and Paste or Paste Special between Excel Workbooks

  1. #1
    Join Date
    Nov 2011
    Posts
    41

    I cannot do Copy and Paste or Paste Special between Excel Workbooks

    We have a number of Excel users in our office who cannot copy and paste between Excel workbooks. They can copy and paste between worksheets. When you highlight the section to copy and then go to the new workbook both the paste and paste special are "grayed out". This is true whether you right-click the mouse, go to the edit menu, or use control keys. This occurs with any data type and the most simple workbooks. I have seen some suggestions here but none have worked for this particular problem. I have reset the menus and renamed the .xlb files and neither helps. You can open the clipboard and the paste will work, but there is no paste special option. Any help would be greatly appreciated. Thanks!

  2. #2
    Join Date
    Nov 2010
    Posts
    505

    Re: I cannot do Copy and Paste or Paste Special between Excel Workbooks

    Do you have the same problem when you open excel in Safe mode. Try opening Excel without any Add-ins or hidden workbook. Click on Start > Run and type C:\Program Files\Microsoft Office\Office\Excel.exe /Safe. Or Excel.exe /Safe

  3. #3
    Join Date
    Mar 2011
    Posts
    544

    Re: I cannot do Copy and Paste or Paste Special between Excel Workbooks

    I just tried what you suggested and I do not have the same problems. What should I check next. I really appreciate your time.

  4. #4
    Join Date
    May 2011
    Posts
    449

    Re: I cannot do Copy and Paste or Paste Special between Excel Workbooks

    It is either an add-in or a (hidden) workbook that is Loaded upon XL's start, which is causing problems. Tools-Addins and uncheck all Addins. Write down which ones were selected. Now close Excel and then reopen. If it is working then one of the Addins was causing the problem. Add them back one at a time, closing and opening Excel each time until you find it. If this didn't stop the problem, then the problem is a file in your xlStart directory. Any file in there Is loaded when you start Excel. Remove the files out of that folder and open Excel to see if the problem is gone. If it is then add them back one at a time, closing and opening Excel each time until you find it.

  5. #5
    Join Date
    Apr 2012
    Posts
    2

    Re: I cannot do Copy and Paste or Paste Special between Excel Workbooks

    Do you use some software like "Grammar check or something"? If yes, remove it out, restate computer, and your excel will be back to normal.

  6. #6
    Join Date
    Apr 2012
    Posts
    2

    Re: I cannot do Copy and Paste or Paste Special between Excel Workbooks

    Sorry i was wrong, It is not from those software.
    Actually, it's from Skype.
    Excel works when you don't open browser like Google Chrome or Fire Fox, (or may be IE)
    The solution is open Google Chrome, Right click on the top of page choose Task Manager, and then choose Skype, click End Process.

    Excel will be back

Similar Threads

  1. Replies: 2
    Last Post: 24-02-2012, 06:22 PM
  2. Want to page negative time via paste special in Excel
    By Ojsuta in forum MS Office Support
    Replies: 4
    Last Post: 24-02-2012, 12:52 PM
  3. How to disable Copy and Paste features in MS Excel
    By Solitario in forum Tips & Tweaks
    Replies: 7
    Last Post: 05-05-2011, 01:36 PM
  4. I am not able to copy and paste data in Excel 2008
    By Apple.Mac.Rocker in forum Windows Software
    Replies: 3
    Last Post: 07-10-2009, 10:27 PM
  5. Replies: 0
    Last Post: 18-03-2009, 10:00 PM

Posting Permissions

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