| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
other workbook does not appear in the drop down box when I attemp.
I attempted to move a worksheet from one workbook to another, but when I
attempted to select the "To Book:" in the drop down box, the only workbooks I had to choose from were the current workbook and a new workbook. The workbook I desired to send the worksheet into was open. How do I get the drop box to recognize other workbooks that are open? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
other workbook does not appear in the drop down box when I attemp.
Is it possible you have two instances of Excel open? If so, try opening both
workbooks under the same instance of Excel. -- Kevin Vaughn "Daniel Loch" wrote: I attempted to move a worksheet from one workbook to another, but when I attempted to select the "To Book:" in the drop down box, the only workbooks I had to choose from were the current workbook and a new workbook. The workbook I desired to send the worksheet into was open. How do I get the drop box to recognize other workbooks that are open? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
other workbook does not appear in the drop down box when I att
Kevin,
You are a superstar. I greatly appreciate your insight. You solved my problem perfectly. Best Regards, Dan "Kevin Vaughn" wrote: Is it possible you have two instances of Excel open? If so, try opening both workbooks under the same instance of Excel. -- Kevin Vaughn "Daniel Loch" wrote: I attempted to move a worksheet from one workbook to another, but when I attempted to select the "To Book:" in the drop down box, the only workbooks I had to choose from were the current workbook and a new workbook. The workbook I desired to send the worksheet into was open. How do I get the drop box to recognize other workbooks that are open? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
other workbook does not appear in the drop down box when I att
Great. Glad it helped.
-- Kevin Vaughn "Daniel Loch" wrote: Kevin, You are a superstar. I greatly appreciate your insight. You solved my problem perfectly. Best Regards, Dan "Kevin Vaughn" wrote: Is it possible you have two instances of Excel open? If so, try opening both workbooks under the same instance of Excel. -- Kevin Vaughn "Daniel Loch" wrote: I attempted to move a worksheet from one workbook to another, but when I attempted to select the "To Book:" in the drop down box, the only workbooks I had to choose from were the current workbook and a new workbook. The workbook I desired to send the worksheet into was open. How do I get the drop box to recognize other workbooks that are open? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Repost:Automatically inserting a row in external workbook | Excel Discussion (Misc queries) | |||
| Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
| Auto updating a workbook with data from another workbook | Excel Discussion (Misc queries) | |||
| How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
| Unprotect Workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
