unable to view all open excel worksheet from window
 

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?

unable to view all open excel worksheet from window
 

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.

"Ileen" wrote:

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?

unable to view all open excel worksheet from window
 

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


On Fri, 2 Jan 2009 13:04:00 -0800, Ileen
wrote:

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?