I've tried to get the same symptom by protecting workbooks etc............no
luck.
Other way to move a sheet is after arranging the windows.
<window< arrange< tiled.
hold control and drag a tab across.

--
Greetings from New Zealand
Bill K

"Kathy" wrote in message
...
Both files are open.

"Bill Kuunders" wrote:

You need to open both files.

--
Greetings from New Zealand
Bill K
"Kathy" wrote in message
...
I have two Excel files containing several sheets each. How do I move a
sheet
from one file (workbook) to another? I tried the move or copy function
in
the file I want to move the sheet from, however, the file I want to
move
the
sheet to does not appear in the "To book" drop down list.