Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wierd Copy and Paste
I'm trying to do a copy and paste (special - values only) between 2
workbooks. I select the cells in one and click the copy button (also have tried Ctrl-c), but when I switch to the other WB and select the arrow beside the Paste button, the top options (Formulas, Values, etc) are grayed out. If I select Paste Special (the bottom option), it gives me a box asking if I want to paste the data as a Excel Worksheet Object, Picture, Bitmap, ... If I try to paste in the same workbook (where I am copying from), the Formulas, Values, etc. options are available. I have each workbook open in separate Excel sessions - I assume this may be causing the problem. But why does it do that? -- Bill @ UAMS |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wierd Copy and Paste
I suspect that each instance of Excel is unaware of the other, so the
Paste operation is in effect coming from an outside source. Do you need to run the workbooks in separate instances of Excel? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wierd Copy and Paste
You are right in the fact that it is to do with Excel being opened in seperate sessions. The target spreadsheet has no idea which application the copy has come from and therefore only offers you the paste options you are seeing. (ie the same as if you were copying from Word to Excel If you opened the spreadsheets from the same session and then tried to copy and paste special you will get the result you are looking for -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=529686 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wierd Copy and Paste
Mark / Gary,
I opened both in the same session - works fine. Thanks for the replies. I guess I have assumed when you do a copy that it puts the data in the clipboard and therefore doesn't care where it is coming from. I'll have to read up on exactly how the clipboard works. -- Bill @ UAMS "Gary Brown" wrote: You are right in the fact that it is to do with Excel being opened in seperate sessions. The target spreadsheet has no idea which application the copy has come from and therefore only offers you the paste options you are seeing. (ie the same as if you were copying from Word to Excel If you opened the spreadsheets from the same session and then tried to copy and paste special you will get the result you are looking for -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=529686 |
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) | |||
Copy / Paste Warning | Excel Discussion (Misc queries) | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) |