other workbook does not appear in the drop down box when I attemp.

G

Guest

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?
 
G

Guest

Is it possible you have two instances of Excel open? If so, try opening both
workbooks under the same instance of Excel.
 
G

Guest

Kevin,

You are a superstar. I greatly appreciate your insight. You solved my
problem perfectly.

Best Regards,

Dan
 
G

Guest

Great. Glad it helped.
--
Kevin Vaughn


Daniel Loch said:
Kevin,

You are a superstar. I greatly appreciate your insight. You solved my
problem perfectly.

Best Regards,

Dan
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
cell w/ drop down then reference 5
Formatted cell column in drop down list 1
Create a drop-down list from a range of cells 2
Office 2007-How do I copy a worksheet from one workbook to another 1
Displaying drop down list arrows 2
Odd Drop Down Box Behavior 4
Drop down list selections creating values in adjoining cell 1

Top