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.
 
Back
Top