unable to view all open excel worksheet from window

[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?

 

[Sean Timmons]

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.

 

[Gord Dibben]

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