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.

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

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?