Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



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

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 05-01-2012
Member
 
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!

Reply With Quote
  #2  
Old 05-01-2012
Member
 
Join Date: Nov 2010
Posts: 500
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
Reply With Quote
  #3  
Old 05-01-2012
Member
 
Join Date: Mar 2011
Posts: 537
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.
Reply With Quote
  #4  
Old 05-01-2012
Member
 
Join Date: May 2011
Posts: 445
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.
Reply With Quote
  #5  
Old 26-04-2012
Member
 
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.
Reply With Quote
  #6  
Old 26-04-2012
Member
 
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
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "I cannot do Copy and Paste or Paste Special between Excel Workbooks"
Thread Thread Starter Forum Replies Last Post
Paste Special function does not work when I copy formulas in Excel Tarani MS Office Support 2 24-02-2012 06:22 PM
Want to page negative time via paste special in Excel Ojsuta MS Office Support 4 24-02-2012 12:52 PM
How to disable Copy and Paste features in MS Excel Solitario Tips & Tweaks 7 05-05-2011 01:36 PM
I am not able to copy and paste data in Excel 2008 Apple.Mac.Rocker Windows Software 3 07-10-2009 10:27 PM
Copy Text from One Cell to Another in Microsoft Excel without copy & paste Computer_Freak Tips & Tweaks 0 18-03-2009 10:00 PM


All times are GMT +5.5. The time now is 10:59 PM.