Do you know for sure you have two instances running?

Close one of them then in the other, FileOpen and select a file to open the
second file.

Now both will be in a single instance.

To prevent in the future try the usual fix.

ToolsOptionsGeneral Uncheck "Ignore Other Applications"

If no joy with that................

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


Gord

On Thu, 14 Aug 2008 16:29:01 -0700, PM Gal
wrote:

How do I open in a single instance?

"Gord Dibben" wrote:

Perhaps you have each workbook open in its own instance of Excel?

Close one instance and open both workbooks in a single instance.


Gord Dibben MS Excel MVP


On Thu, 14 Aug 2008 15:14:04 -0700, PM Gal <PM
wrote:

When I select the worksheet to be moved and to the Edit menu and click- Move
or Copy Sheet- the workbook to which I want to move the worksheet doesn't
appear in the To BOX , eventhough I have the receiving workbook open. What
must I do to have the new workbook listed in the TO BOX so I can complete the
worksheet's move?