Moving a Worksheet

[Guest]

I'm attempting to move a worksheet from Workbook A to Workbook B. Both
workbooks are open. When I select "Move or Copy" from Workbook A, Workbook B
is not listed in the "To Boob" dropdown menu, so I am unable to complete the
move.

I have recently upgraded to Excel 2007, but never encountered this problem
in 2003.

Thanks for any help you can give.

 

[Guest]

Sorry for the typing error. I meant to type "To Book" instead of "To Boob".

 

[Gord Dibben]

Sounds like you have two separate instances of Excel running.

One can't see the other.

Close one instance and open both books in one instance.


Gord Dibben MS Excel MVP

 

[Guest]

Gord - Thanks for looking/responding. Since the original post, I found that
things work fine if I open files through Excel rather than through Explorer.
I had posted a second question including the new details. Eventually, I
found a fix, and posted the fix in my second question, but I should post it
here as well. Thanks again.

Here is my problem/fix from the other post:

Thanks for looking at my post, but I found the answer on my own. If anyone
else has a similar problem, here is what I did to fix it:

I copied the settings/switches from the newest Excel file format; i.e. I
went to Tools/Folder Options/File Types. Then I scrolled to XLSX and copied
these the settings to XLS. That fixed my problem. I may find that it
causes another problem later, but I'll cross that bridge when I get there.

 

[Gord Dibben]

Thanks for the feedback.

Sometimes this fix will work.

Go to Tools>Options>General and make sure "ignore other applications" is not
checked.


Gord

 

[Guest]

Thanks Gord, but I don't think Excel 2007 has a tool menu, which is
frustrating.

 

[Gord Dibben]

Shows how well I read posts.

Missed that part about................Can anyone using Excel 2007 please respond
with default values for these settings?

All I read was "opening 2003 files" and never went any further<g>


Gord