unable to view all open excel worksheet from window

  • Thread starter Thread starter Ileen
  • Start date Start date
I

Ileen

When I attempt to copy a worksheet into an open workbook (Edit, Move or Copy
Worksheet) I do not have a complete list of open files, even if I only have 2
files open. This is a new occurence.

Any suggestions?
 
If you have the files open in two instances of Excel, this will occur. If you
open all files using file-Open, they should all be in the same instance.

If, instead, you opened Excel itself and opened a file, that's a separat
instance that won't be recognized.
 
Do you have more than one instance of Excel running?

If so, they won't communicate.

You must close one instance and open all books in a single instance to
regain your list of open books.


Gord Dibben MS Excel MVP
 
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

Cannot copy worksheet to another file 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Protection 2
Need help moving a worksheet to another workbook. 4
Opening Excel files 1
Moving a Worksheet 6
Excel Move or Copy Stopped Working? 0
Move/Copy Worksheet with Macros 2

Back
Top