| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't copy between workbooks
For some reason Excel won't let me copy and paste from one open workbook to another. I can copy and paste between worksheets in the same book, but not between different workbooks. I tried going through options & preferences but didn't see anything that looked suspicious. I use to be able to copy between books, but all of a sudden can't. Any suggestions?? Thanks so much! -- Sibil71 ------------------------------------------------------------------------ Sibil71's Profile: http://www.officehelp.in/member.php?userid=4856 View this thread: http://www.officehelp.in/showthread.php?t=1246355 Posted from - http://www.officehelp.in |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't copy between workbooks
Sibil71 wrote: For some reason Excel won't let me copy and paste from one open workbook to another. I can copy and paste between worksheets in the same book, but not between different workbooks. I tried going through options & preferences but didn't see anything that looked suspicious. I use to be able to copy between books, but all of a sudden can't. Any suggestions?? Thanks so much! -- Sibil71 ------------------------------------------------------------------------ Sibil71's Profile: http://www.officehelp.in/member.php?userid=4856 View this thread: http://www.officehelp.in/showthread.php?t=1246355 Posted from - http://www.officehelp.in |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't copy between workbooks
Sorry for the posting error. Try to see whether the workbooks are
protected. Otherwise, please give me more details about what you would like to do! Thanks, George George wrote: Sibil71 wrote: For some reason Excel won't let me copy and paste from one open workbook to another. I can copy and paste between worksheets in the same book, but not between different workbooks. I tried going through options & preferences but didn't see anything that looked suspicious. I use to be able to copy between books, but all of a sudden can't. Any suggestions?? Thanks so much! -- Sibil71 ------------------------------------------------------------------------ Sibil71's Profile: http://www.officehelp.in/member.php?userid=4856 View this thread: http://www.officehelp.in/showthread.php?t=1246355 Posted from - http://www.officehelp.in |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't copy between workbooks
Won't allow copy/paste or won't copy/paste correctly?
Could be you are opening the two workbooks each in a separate instance of Excel. Try opening both books in one instance. Gord Dibben MS Excel MVP On Mon, 30 Oct 2006 20:20:56 +0530, Sibil71 wrote: For some reason Excel won't let me copy and paste from one open workbook to another. I can copy and paste between worksheets in the same book, but not between different workbooks. I tried going through options & preferences but didn't see anything that looked suspicious. I use to be able to copy between books, but all of a sudden can't. Any suggestions?? Thanks so much! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't copy between workbooks
The workbooks are not protected. It's any workbook I open. And I use Excel for work so there are times when I need to copy formats or formulas, etc. from one workbook to another. Thanks, Kim -- Sibil71 ------------------------------------------------------------------------ Sibil71's Profile: http://www.officehelp.in/member.php?userid=4856 View this thread: http://www.officehelp.in/showthread.php?t=1246355 Posted from - http://www.officehelp.in |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't copy between workbooks
Gord Dibben;3906118 Wrote: Won't allow copy/paste or won't copy/paste correctly? Could be you are opening the two workbooks each in a separate instance of Excel. Try opening both books in one instance. Gord Dibben MS Excel MVP Excel won't let me paste at all, it just beeps when I try. Even when I have the files open in separate windows. The only way I have been able to paste is by copying the entire spreadsheet from book 1 to book 2, and then copying from the spreadsheet once it's in workbook 2, which is a pain. -- Sibil71 ------------------------------------------------------------------------ Sibil71's Profile: http://www.officehelp.in/member.php?userid=4856 View this thread: http://www.officehelp.in/showthread.php?t=1246355 Posted from - http://www.officehelp.in |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't copy between workbooks
How are you opening the two workbooks?
Double-click on files or from FileOpen? When you have one workbook open and you open the second one does a new instance of Excel start up? The term "spreadsheet" means one worksheet in a workbook? Gord On Tue, 31 Oct 2006 01:00:46 +0530, Sibil71 wrote: Gord Dibben;3906118 Wrote: Won't allow copy/paste or won't copy/paste correctly? Could be you are opening the two workbooks each in a separate instance of Excel. Try opening both books in one instance. Gord Dibben MS Excel MVP Excel won't let me paste at all, it just beeps when I try. Even when I have the files open in separate windows. The only way I have been able to paste is by copying the entire spreadsheet from book 1 to book 2, and then copying from the spreadsheet once it's in workbook 2, which is a pain. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't copy between workbooks
I double-click to open Excel and yes they each open in separate instances. And yes I meant worksheet instead of spreadsheet. Kim Gord Dibben;3907412 Wrote: How are you opening the two workbooks? Double-click on files or from FileOpen? When you have one workbook open and you open the second one does a new instance of Excel start up? The term "spreadsheet" means one worksheet in a workbook? Gord -- Sibil71 ------------------------------------------------------------------------ Sibil71's Profile: http://www.officehelp.in/member.php?userid=4856 View this thread: http://www.officehelp.in/showthread.php?t=1246355 Posted from - http://www.officehelp.in |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't copy between workbooks
Go into ToolsOptionsGeneral and uncheck "ignore other applications".
Close Excel then your two workbooks should open in a single instance of Excel. Your copy/paste problems should go away. Gord On Tue, 31 Oct 2006 20:09:17 +0530, Sibil71 wrote: I double-click to open Excel and yes they each open in separate instances. And yes I meant worksheet instead of spreadsheet. Kim Gord Dibben;3907412 Wrote: How are you opening the two workbooks? Double-click on files or from FileOpen? When you have one workbook open and you open the second one does a new instance of Excel start up? The term "spreadsheet" means one worksheet in a workbook? Gord |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't copy between workbooks
"Ignore other applications" was already unchecked on my Excel. Once I checked it my 2 workbooks opened in the same instance...the opposite of what you said. But I still wasn't able to copy and paste between the workbooks, even with them being open in the same instance. Kim Gord Dibben;3911067 Wrote: Go into ToolsOptionsGeneral and uncheck "ignore other applications". Close Excel then your two workbooks should open in a single instance of Excel. Your copy/paste problems should go away. Gord -- Sibil71 ------------------------------------------------------------------------ Sibil71's Profile: http://www.officehelp.in/member.php?userid=4856 View this thread: http://www.officehelp.in/showthread.php?t=1246355 Posted from - http://www.officehelp.in |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't copy between workbooks
Thanks anyway for the help. Kim Gord Dibben;3912045 Wrote: I have no more ideas except trying re-registering Excel. Close Excel first and On the Windows Taskbar 1) StartRun "excel.exe /unregserver"(no quotes)OK. 2) StartRun "excel.exe /regserver"(no quotes)OK. See the space between exe and /regserver You might have to designate a full path to excel.exe. In that case StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK Gord -- Sibil71 ------------------------------------------------------------------------ Sibil71's Profile: http://www.officehelp.in/member.php?userid=4856 View this thread: http://www.officehelp.in/showthread.php?t=1246355 Posted from - http://www.officehelp.in |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy headers/footers to multiple different workbooks? | Excel Discussion (Misc queries) | |||
| Copy a range from closed workbooks (ADO) | Excel Discussion (Misc queries) | |||
| How do I create a formula to copy and paste between workbooks? | Excel Discussion (Misc queries) | |||
| reminder notifications in a column | Excel Discussion (Misc queries) | |||
| Excel won't copy outside sheet | Excel Discussion (Misc queries) | |||
Linear Mode
