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

>> Friday 8 June 2012

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
Gania Gania is offline
Member

Join Date: Nov 2010
Posts: 480
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
Erakna Erakna is offline
Member

Join Date: Mar 2011
Posts: 507
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
GaganjyotTechie GaganjyotTechie is offline
Member

Join Date: May 2011
Posts: 432
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
vbquoc vbquoc is offline
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
vbquoc vbquoc is offline
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

0 comments:

Post a Comment

Read - Share - Comment

About This Blog

Share and Save

About Author