Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't Copy and Paste between Workbooks
I am unable to copy from one workbook to another workbook. What I should say
is that I can copy but when I go the other workbook, Paste is grayed out. If I open a second instance of Excel, Copy and Paste will work between the 2 instances but not between workbooks in a single instance of Excel. This is only happening on 1 computer out of 25 that we have at this office. I checked in Tools-Options-Edit and made sure that the Paste option was checked. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't Copy and Paste between Workbooks
One of the side effects of macros is that the contents of the clipboard is lost.
It sounds like you have a macro running--maybe a worksheet_activate or a workbook_activate or even an application event. I'd look to see if you have any of those type macros that are running. Tom at Galanti & Company PC wrote: I am unable to copy from one workbook to another workbook. What I should say is that I can copy but when I go the other workbook, Paste is grayed out. If I open a second instance of Excel, Copy and Paste will work between the 2 instances but not between workbooks in a single instance of Excel. This is only happening on 1 computer out of 25 that we have at this office. I checked in Tools-Options-Edit and made sure that the Paste option was checked. Any ideas? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't Copy and Paste between Workbooks
A quick way to determine if this is the case is to copy on one file go to the
file where paste is grayed out, select a cell and then go back to the original file and see if you can paste there. Check the personal XLS for macros on the computer for which this happens. "Dave Peterson" wrote: One of the side effects of macros is that the contents of the clipboard is lost. It sounds like you have a macro running--maybe a worksheet_activate or a workbook_activate or even an application event. I'd look to see if you have any of those type macros that are running. Tom at Galanti & Company PC wrote: I am unable to copy from one workbook to another workbook. What I should say is that I can copy but when I go the other workbook, Paste is grayed out. If I open a second instance of Excel, Copy and Paste will work between the 2 instances but not between workbooks in a single instance of Excel. This is only happening on 1 computer out of 25 that we have at this office. I checked in Tools-Options-Edit and made sure that the Paste option was checked. Any ideas? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't Copy and Paste between Workbooks
Actually, if I wanted to check to see if this was a macro related problem, I'd
open excel in safe mode so that all the macros would be disabled: close excel windows start button|Run excel /safe File|open both workbooks and test it out. If it worked there, I would look under under the ThisWorkbook module of each workbook first. Then I would look for a workbook that may have tied into application events. This could include Personal.xls, but it doesn't have to be personal.xls. bj wrote: A quick way to determine if this is the case is to copy on one file go to the file where paste is grayed out, select a cell and then go back to the original file and see if you can paste there. Check the personal XLS for macros on the computer for which this happens. "Dave Peterson" wrote: One of the side effects of macros is that the contents of the clipboard is lost. It sounds like you have a macro running--maybe a worksheet_activate or a workbook_activate or even an application event. I'd look to see if you have any of those type macros that are running. Tom at Galanti & Company PC wrote: I am unable to copy from one workbook to another workbook. What I should say is that I can copy but when I go the other workbook, Paste is grayed out. If I open a second instance of Excel, Copy and Paste will work between the 2 instances but not between workbooks in a single instance of Excel. This is only happening on 1 computer out of 25 that we have at this office. I checked in Tools-Options-Edit and made sure that the Paste option was checked. Any ideas? -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't Copy and Paste between Workbooks
Thanks guys. I do believe you have pointed me in the right driection. After
installing a new application, I do know that this new app installed some macros with it to support itself. I'm willing to bet this is where I need to do my investigation. After I check this out, I'll post what I found in case anyone else is having a similiar problem. "Dave Peterson" wrote: Actually, if I wanted to check to see if this was a macro related problem, I'd open excel in safe mode so that all the macros would be disabled: close excel windows start button|Run excel /safe File|open both workbooks and test it out. If it worked there, I would look under under the ThisWorkbook module of each workbook first. Then I would look for a workbook that may have tied into application events. This could include Personal.xls, but it doesn't have to be personal.xls. bj wrote: A quick way to determine if this is the case is to copy on one file go to the file where paste is grayed out, select a cell and then go back to the original file and see if you can paste there. Check the personal XLS for macros on the computer for which this happens. "Dave Peterson" wrote: One of the side effects of macros is that the contents of the clipboard is lost. It sounds like you have a macro running--maybe a worksheet_activate or a workbook_activate or even an application event. I'd look to see if you have any of those type macros that are running. Tom at Galanti & Company PC wrote: I am unable to copy from one workbook to another workbook. What I should say is that I can copy but when I go the other workbook, Paste is grayed out. If I open a second instance of Excel, Copy and Paste will work between the 2 instances but not between workbooks in a single instance of Excel. This is only happening on 1 computer out of 25 that we have at this office. I checked in Tools-Options-Edit and made sure that the Paste option was checked. Any ideas? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
How do I copy and paste formulas between workbooks? | Excel Discussion (Misc queries) | |||
Copy/Paste hyperlinks between workbooks | Excel Discussion (Misc queries) | |||
copy and paste with 2 different workbooks problem | Excel Worksheet Functions | |||
Copy and paste between workbooks | Excel Discussion (Misc queries) |