Re: Can't copy between workbooks

[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

 

[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

 

[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

 

[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

Gord Dibben MS Excel MVP