View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Need help moving a worksheet to another workbook.

Close one of the instances of excel.

Then in the remaining running instance, use File|Open to open the 2nd workbook.

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?




--

Dave Peterson