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

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

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

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!

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

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

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.

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

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

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

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