Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cannot copy from one workbook to another
For some reason I cannot copy from one workbook to another. My typical
method for copying is to hit Ctrl+C, switch workbooks, then hit Ctrl+V although attempts to use the toolbar and right-clicking don't seem to work either. The copy function works fine. I get the "marching ants" to indicate the area I've selected to copy. However, when I switch to another workbook, the clipboard seems to empty itself so I cannot paste what I've copied. I can copy/paste within the same workbook without a problem. This only occurs when I want to copy from one workbook to another. Any help would be appreciated. Mike. |
#2
|
|||
|
|||
How do you switch between the workbooks? If you use a keyboard shortcut maybe
a macro interferes and clears the clipboard? Regards, Peo Sjoblom "Michael Malinsky" wrote: For some reason I cannot copy from one workbook to another. My typical method for copying is to hit Ctrl+C, switch workbooks, then hit Ctrl+V although attempts to use the toolbar and right-clicking don't seem to work either. The copy function works fine. I get the "marching ants" to indicate the area I've selected to copy. However, when I switch to another workbook, the clipboard seems to empty itself so I cannot paste what I've copied. I can copy/paste within the same workbook without a problem. This only occurs when I want to copy from one workbook to another. Any help would be appreciated. Mike. |
#3
|
|||
|
|||
I switch between the workbooks using either the taskbar or Alt+Tab. I
have no keyboard shortcuts at all. |
#4
|
|||
|
|||
Do you have any macros running (even events _activate and _deactivate (workbook
or worksheet)))? If you close excel and reopen in safe mode (which will disable all macros), does it work? close excel windows start button|run excel /safe file|Open both workbooks. Michael Malinsky wrote: I switch between the workbooks using either the taskbar or Alt+Tab. I have no keyboard shortcuts at all. -- Dave Peterson |
#5
|
|||
|
|||
Dave,
I have the same problem in safe mode. Thanks anyway. Anyone else? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy sheet to new workbook | Excel Discussion (Misc queries) | |||
What's the simplest way to copy data from another workbook | Excel Worksheet Functions | |||
copy COLUMN from 1 worksheet to another (in a different workbook) | Excel Discussion (Misc queries) | |||
copy a workbook from other workbook with lot of sheets wit... | Excel Discussion (Misc queries) | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions |