| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help moving a worksheet to another workbook.
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help moving a worksheet to another workbook.
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help moving a worksheet to another workbook.
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help moving a worksheet to another workbook.
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving worksheets to new workbook | New Users to Excel | |||
| Moving Cell Information from one workbook into another workbook | Excel Worksheet Functions | |||
| Moving Sheets within a workbook | Excel Worksheet Functions | |||
| Moving one workbook page to a new workbook | Excel Worksheet Functions | |||
| Moving a chart from one workbook to another | Charts and Charting in Excel | |||
Hybrid Mode
