Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jb0100 - 29 May 2008 20:44 GMT
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.
sb1920alk - 29 May 2008 21:39 GMT
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.

> 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
[quoted text clipped - 8 lines]
>
> Cheers.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.