Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
wllee
 
Posts: n/a
Default Can't 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   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Can't Copy and Paste or Paste Special between Excel Workbooks

It sounds like the issue may be related to the Excel settings or the clipboard. Here are some steps you can try to resolve the issue:
  1. Check the Excel Options: Go to File Options Advanced. Scroll down to the "Cut, copy, and paste" section and make sure the "Show Paste Options" box is checked. Also, check the settings under "Cut, copy, and paste" to ensure they are set to your desired preferences.
  2. Clear the Clipboard: Sometimes the clipboard can become corrupted and cause issues with copying and pasting. To clear the clipboard, open the Clipboard pane by clicking on the Clipboard group in the Home tab. Then, click on the Clear All button to clear the clipboard.
  3. Check for Add-ins: Add-ins can sometimes interfere with Excel's functionality. Go to File Options Add-ins and check if there are any add-ins listed. If there are, try disabling them and see if the issue persists.
  4. Repair Office: If none of the above steps work, try repairing your Office installation. Go to Control Panel Programs and Features, select Microsoft Office, and click on Change. Then, select "Repair" and follow the prompts to repair your Office installation.

Hopefully, one of these steps will resolve the issue and allow you to copy and paste between Excel workbooks.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Do you have the same problem when you open excel in Safe modus

Try opening Excel without any Add-ins or hidden workbooks:
StartRun
"C:\Program Files\Microsoft Office\Office\Excel.exe" /Safe
Or Excel.exe /Safe


--
Regards Ron de Bruin
http://www.rondebruin.nl



"wllee" wrote in message ...
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!



  #4   Report Post  
wllee
 
Posts: n/a
Default

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

Bill

"Ron de Bruin" wrote:

Do you have the same problem when you open excel in Safe modus

Try opening Excel without any Add-ins or hidden workbooks:
StartRun
"C:\Program Files\Microsoft Office\Office\Excel.exe" /Safe
Or Excel.exe /Safe


--
Regards Ron de Bruin
http://www.rondebruin.nl



"wllee" wrote in message ...
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!




  #5   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi Bill

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



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

Bill

"Ron de Bruin" wrote:

Do you have the same problem when you open excel in Safe modus

Try opening Excel without any Add-ins or hidden workbooks:
StartRun
"C:\Program Files\Microsoft Office\Office\Excel.exe" /Safe
Or Excel.exe /Safe


--
Regards Ron de Bruin
http://www.rondebruin.nl



"wllee" wrote in message ...
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!








  #6   Report Post  
wllee
 
Posts: n/a
Default

Thanks very much for your time, I have figured it out. It was an
obetexcelvbacommon addin that was causing the problem or actually the lack of
it.

Thanks again,

Bill

"Ron de Bruin" wrote:

Hi Bill

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



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

Bill

"Ron de Bruin" wrote:

Do you have the same problem when you open excel in Safe modus

Try opening Excel without any Add-ins or hidden workbooks:
StartRun
"C:\Program Files\Microsoft Office\Office\Excel.exe" /Safe
Or Excel.exe /Safe


--
Regards Ron de Bruin
http://www.rondebruin.nl



"wllee" wrote in message ...
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't Copy and Paste between Excel 2003 Workbooks wllee Excel Discussion (Misc queries) 6 March 30th 05 02:59 PM
Keyboard shortcut for "copy paste special values?" Star AJ Excel Discussion (Misc queries) 2 March 17th 05 05:03 PM
paste special (values) AJPendragon Excel Worksheet Functions 0 February 22nd 05 04:19 PM
Paste Special values only AJPendragon Excel Worksheet Functions 1 February 22nd 05 12:05 PM
Paste Special FLKULCHAR Excel Discussion (Misc queries) 2 December 29th 04 08:19 AM


All times are GMT +1. The time now is 11:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"