Can't copy between workbooks

S

Sibil71

For some reason Excel won't let me copy and paste from one open workboo
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 b
able to copy between books, but all of a sudden can't. Any suggestions?
Thanks so much
 
G

George

Sibil71 said:
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
Click to expand...
 
G

George

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,
 
G

Gord Dibben

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
 
S

Sibil71

The workbooks are not protected. It's any workbook I open. And I us
Excel for work so there are times when I need to copy formats o
formulas, etc. from one workbook to another.

Thanks,
Ki
 
S

Sibil71

Gord said:
Won't allow copy/paste or won't copy/paste correctly?

Could be you are opening the two workbooks each in a separate instanc
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
have the files open in separate windows. The only way I have been abl
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 i
a pain
Click to expand...
 
G

Gord Dibben

How are you opening the two workbooks?

Double-click on files or from File>Open?

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
 
S

Sibil71

I double-click to open Excel and yes they each open in separat
instances. And yes I meant worksheet instead of spreadsheet.

Kim
 
G

Gord Dibben

Go into Tools>Options>General 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
 
S

Sibil71

"Ignore other applications" was already unchecked on my Excel. Once
checked it my 2 workbooks opened in the same instance...the opposite o
what you said. But I still wasn't able to copy and paste between th
workbooks, even with them being open in the same instance.

Kim
 
G

Gord Dibben

I have no more ideas except trying re-registering Excel.

Close Excel first and On the Windows Taskbar

1) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "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 Start>Run "C:\yourpath\excel.exe /regserver"(no quotes)>OK


Gord

"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
Click to expand...

Gord Dibben MS Excel MVP
 
S

Sibil71

Thanks anyway for the help.

Kim



I have no more ideas except trying re-registering Excel.

Close Excel first and On the Windows Taskbar

1) Start>Run "excel.exe /unregserver"(no quotes)>OK.
2) Start>Run "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 Start>Run "C:\yourpath\excel.exe /regserver"(n
quotes)>OK


Gor
Click to expand...
 
Top