Can not copy a sheet to another book

[dveer]

When I open 2 workbooks in 2 instances of Excel on my computer, I can not
copy a sheet from one book to the other. It is also not possible to tile the
2 files.
When I open both files in the same instance, it it possible to select the
other file in the dropdown list.
Since I usually open the files from Explorer, I would like to be able to
tile & copy when multiple files are opened.
What setting should I change?

 

[Don Guillett]

I would suggest opening your files using EXCEL.

 

[dveer]

I was hoping for some more advanced tips :-(
It works on most of the other computers in our office

 

[Gord Dibben]

One usual fix for this is in Excel

Tools>Options>General and uncheck "ignore other applications"


Gord Dibben MS Excel MVP

 

[dveer]

Unfortunately this also did not help, this box was already unchecked.
Any other ideas?

 

[Gord Dibben]

I would suggest you re-register Excel

Close Excel first and On the Windows Taskbar

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(quotes
required)>OK


Gord

 

[dveer]

Thanks Gord, this solved the problem!

I would suggest you re-register Excel

Close Excel first and On the Windows Taskbar

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(quotes
required)>OK


Gord




.

 

[Gord Dibben]

Good to hear.

Thanks for the feedback

Thanks Gord, this solved the problem!