Moving worksheets to another book - 2nd book will not appear

  • Thread starter Thread starter jb0100
  • Start date Start date
J

jb0100

I am trying tomove (or copy) one worksheet to another book, but when I right
click on the worksheet i want to move, the second book does not appear in the
"to book:" pull down.

BTW, the second book is open as well.

Microsoft help says they have to be on the same instance, no clue what that
means.

Any ideas?

Cheers.
 
Difference instances mean Windows has two copies of Excel running, each with
one workbook open. Instead, you want to have one copy of Excel running with
two workbooks open. Close one of the workbooks (and that instance of Excel).
In the other one, re-open the file you just closed through the File menu
(instead of double-clicking it). Now it should work as you intended.
 
Thank you! I was getting so frustrated trying to figure out the problem!!
 
You must log in or register to reply here.

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

Excel Move or Copy Stopped Working? 0
copy worksheets to new book without linking to original book 2
Locking a reference from one worksheet to another, in the same book(without moving when a row is add 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
A Good Second Book on VBA 1
Move & Copy Problem, Limit? 3
Copy or Move a spreadsheet 1
Pivot Table: Copy from one Book to another 1

Back
Top